|
发表于 2020-8-27 15:15:01
|
显示全部楼层
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; |
|