How to generate the DDL of any object in ORACLE?
SELECT DBMS_METADATA.get_ddl (
<OBJECT_TYPE>,
<OBJECT_NAME>,
<SCHEMA_NAME>)
FROM DUAL;
SELECT DBMS_METADATA.get_ddl (
<OBJECT_TYPE>,
<OBJECT_NAME>,
<SCHEMA_NAME>)
FROM DUAL;