Oracle Get DDL for an object
From WickyWiki
The result will be a create-table statement:
SELECT DBMS_METADATA.GET_DDL('TABLE','USER1.TABLE1') from dual;
The result will be a create-table statement:
SELECT DBMS_METADATA.GET_DDL('TABLE','USER1.TABLE1') from dual;