Search This Blog

Saturday, February 4, 2023

Get DDL of any Object in Oracle

SELECT DBMS_METADATA.get_ddl (<OBJECT_TYPE>, <OBJECT_NAME>, <SCHEMA_NAME>) FROM DUAL; --Must write everything in capital word


No comments:

Post a Comment

Restrict File Upload by File Type in Oracle Apex

If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --...