oracl 查看建表语句

QL> SELECT DBMS_METADATA.GET_DDL('TABLE', 'EOSROLE') FROM DUAL;

  CREATE TABLE "COFCO_LAW"."EOSROLE"
   (    "ROLEID" VARCHAR2(64) NOT NULL ENABLE,
        "GROUPID" VARCHAR2(20),
        "ROLENAME" VARCHAR2(64) NOT NULL ENABLE,
        "ROLECLASS" NUMBER(*,0),
        "PRIORITY" VARCHAR2(2),
        "QUERYSCOPE" VARCHAR2(30),
        "DFLAG" CHAR(1) DEFAULT 0,
         CONSTRAINT "PK_EOSROLE" PRIMARY KEY ("ROLEID")
  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 "COFCO_LAW"  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 "COFCO_LAW"