uj5u.com熱心網友回復：
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
uj5u.com熱心網友回復：
可以查詢 col、user_tab_columns，這兩個視圖。uj5u.com熱心網友回復：
select * from all_tab_columns where table_name = 'EMP' ;轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/86457.html
標籤：開發
上一篇：關于同義詞的問題