sqlplus查看表DDL

[sys@ORCL]#select dbms_metadata.get_ddl('TABLE','T','SYS') from dual; DBMS_METADATA.GET_DDL('TABLE','T','SYS') -------------------------------------------------------------------------------- CREATE TABLE "SYS"."T" ( "OWNER" VARCHAR2(30), "OBJECT_NAME" VARCHAR2(30), "SUBOBJECT_NAME" VARCHAR2(30), "OBJECT_ID" NUMBER, "DATA_OBJECT_ID" NUMBER, "OBJECT_TYPE" VARCHAR2(19), "CREATED" DATE, "LAST_DDL_TIME" DATE, "TIMESTAMP" VARCHAR2(19), "STATUS" VARCHAR2(7), "TEMPORARY" VARCHAR2(1), "GENERATED" VARCHAR2(1), "SECONDARY" VARCHAR2(1) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "TMP" LOCATION ( 'allobjects.dat' ) ) 

语法：

select dbms_metadata.get_ddl('TABLE','TABLE_NAME','schema_name') from dual;