获得表的ddl语句 以查看表结构

参考《oracle dba工作笔记》中脚本

SQL> SET SERVEROUTPUT ON;

SQL> SET LINESIZE 500;
SQL> SET FEEDBACK OFF;
SQL> SET LONG 99999999     ;   
SQL> SET PAGESIZE 1000 ;  
SQL> set head off;
SQL> EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false); 
SQL> EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'PRETTY',true); 
SQL> EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',true); 
SQL> EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'TABLESPACE',true); 
SQL> EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES',false); 
SQL> EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'REF_CONSTRAINTS',false); 
SQL> select DBMS_METADATA.GET_DDL('TABLE','WORKER','TEST')from dual;




  CREATE TABLE "TEST"."WORKER"
   (    "WNO" CHAR(9),
        "WNAME" CHAR(20) NOT NULL ENABLE,
         PRIMARY KEY ("WNO")
  USING INDEX  ENABLE
   ) ;