SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','EMP') FROM DUAL;
DBMS_METADATA.GET_DDL('TABLE',
--------------------------------------------------------------------------------
CREATE TABLE "PEC"."EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10) CONSTRAINT "BIN$VD4eNL77NVrgU4BkYApSLw==$0" NOT NULL ENABL
"JOB" VARCHAR2(9),
"MGR" NUMBER(4,0),
"HIREDATE" DATE DEFAULT SYSDATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0),
"COMMENTS" VARCHAR2(300),
CONSTRAINT "BIN$VD4eNL76NVrgU4BkYApSLw==$0" PRIMARY KEY ("EMPNO")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DRP" ENABLE,
CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")
REFERENCES "PEC"."DEPT" ("DEPTNO") ENABLE
) SEGMENT CREATION IMMEDIATE
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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DRP"
SQL> desc emp;
Name Type Nullable Default Comments
-------- ------------- -------- ------- --------
EMPNO NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9) Y
MGR NUMBER(4) Y
HIREDATE DATE Y SYSDATE
SAL NUMBER(7,2) Y
COMM NUMBER(7,2) Y
DEPTNO NUMBER(2) Y
COMMENTS VARCHAR2(300) Y
DBMS_METADATA.GET_DDL('TABLE',
--------------------------------------------------------------------------------
CREATE TABLE "PEC"."EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10) CONSTRAINT "BIN$VD4eNL77NVrgU4BkYApSLw==$0" NOT NULL ENABL
"JOB" VARCHAR2(9),
"MGR" NUMBER(4,0),
"HIREDATE" DATE DEFAULT SYSDATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0),
"COMMENTS" VARCHAR2(300),
CONSTRAINT "BIN$VD4eNL76NVrgU4BkYApSLw==$0" PRIMARY KEY ("EMPNO")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DRP" ENABLE,
CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")
REFERENCES "PEC"."DEPT" ("DEPTNO") ENABLE
) SEGMENT CREATION IMMEDIATE
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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DRP"
SQL> desc emp;
Name Type Nullable Default Comments
-------- ------------- -------- ------- --------
EMPNO NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9) Y
MGR NUMBER(4) Y
HIREDATE DATE Y SYSDATE
SAL NUMBER(7,2) Y
COMM NUMBER(7,2) Y
DEPTNO NUMBER(2) Y
COMMENTS VARCHAR2(300) Y
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货