select DBMS_METADATA.GET_DDL(对象类型,对象名称) from dual;对象类型: CLUSTER TABLE 表 INDEX REF_CONSTRAINT CONSTRAINT VIEW 视图 TYPE FUNCTION PROCEDURE PACKAGE SEQUENCE TRIGGER SYNONYM DB_LINK如: select DBMS_METADATA.GET_DDL('TABLE','MYTABLE') from dual;
如果要同时获取多个表的结构: select DBMS_METADATA.GET_DDL('TABLE',table_name) from USER_TABLES;
[email protected]
CLUSTER
TABLE 表
INDEX
REF_CONSTRAINT
CONSTRAINT
VIEW 视图
TYPE
FUNCTION
PROCEDURE
PACKAGE
SEQUENCE
TRIGGER
SYNONYM
DB_LINK如:
select DBMS_METADATA.GET_DDL('TABLE','MYTABLE') from dual;
select DBMS_METADATA.GET_DDL('TABLE',table_name) from USER_TABLES;