得到建表DDL语句

除了用PL/SQL DEV，Toad等工具得到建表DDL语句，使用dbms_metadata.get_ddl也可以，用法如下。且不仅限与表，所有对象都可以

dbms_metadata.get_ddl('OBJECT_TYPE','OBJECT_NAME','OWNER')


SQL> select dbms_metadata.get_ddl('SYNONYM','DCUSTMSGHIS','PUBLIC') from dual;

DBMS_METADATA.GET_DDL('SYNONYM','DCUSTMSGHIS','PUBLIC')
--------------------------------------------------------------------------------

CREATE PUBLIC SYNONYM "DCUSTMSGHIS" FOR "DBACCADM"."DCUSTMSGHIS"


select dbms_metadata.get_ddl('TABLE','WCHG201305','DBCUSTADM') FROM DUAL;

select dbms_metadata.get_ddl('INDEX','PK_WCHG201305','DBCUSTADM') FROM DUAL;