Generate the DDL of any object in ORACLE

September 23, 2021Posted inAPEX

How to generate the DDL of any object in ORACLE?

Copy Code
SELECT DBMS_METADATA.get_ddl (
                       <OBJECT_TYPE>,
                       <OBJECT_NAME>,
                       <SCHEMA_NAME>)
              FROM DUAL;