Generate DDL of any object in ORACLE Ashish Sahay Sep 23, 2021 1 min read Ashish SahayORACLESQLDDLOBJECTDBMS_METADATA How to generate DDL of any object in ORACLE? SELECT DBMS_METADATA.get_ddl ( <OBJECT_TYPE>, <OBJECT_NAME>, <SCHEMA_NAME>) FROM DUAL;