ORACLE SQL リファレンス(逆引き)

SQL> set long 2000
SQL> set heading off
SQL>
SQL> select
　2　　 dbms_metadata.get_ddl('TABLE','EMP')
　3 　　from dual;

CREATE TABLE "TEST"."EMP"
( 　 "EMP_ID" CHAR(5),
　　"DEPT_ID" CHAR(5),
　　"EMP_NAME" VARCHAR2(10),
　　"EMP_DATE" DATE,
　　"SALARY" NUMBER(5,0),
PRIMARY KEY ("EMP_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"

set long 2000
set heading off
set line 120
set pages 2000
set long 2000
set heading off
set trimspool off
set feedback off
set longchunksize 600

EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(
DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',TRUE)

spool create_table.sql

select
dbms_metadata.get_ddl('TABLE',table_name)
from user_tables;

spool off;