SQL> desc dbms_metadataFUNCTION ADD_TRANSFORM RETURNS NUMBER...FUNCTION GET_DDL RETURNS CLOB Argument Name                  Type                    In/Out Default? ------------------------------ ----------------------- ------ -------- OBJECT_TYPE                    VARCHAR2                IN NAME                           VARCHAR2                IN SCHEMA                         VARCHAR2                IN     DEFAULT VERSION                        VARCHAR2                IN     DEFAULT MODEL                          VARCHAR2                IN     DEFAULT TRANSFORM                      VARCHAR2                IN     DEFAULT....
SQL> set long 2000
SQL> select dbms_metadata.get_ddl('TABLE','TEST') from dual;
DBMS_METADATA.GET_DDL('TABLE','TEST')
--------------------------------------------------------------------------------
  CREATE TABLE "SYS"."TEST"
   (    "OWNER" VARCHAR2(30),
        "OBJECT_NAME" VARCHAR2(128),
        "SUBOBJECT_NAME" VARCHAR2(30),
        "OBJECT_ID" NUMBER,
        "DATA_OBJECT_ID" NUMBER,
        "OBJECT_TYPE" VARCHAR2(18),
        "CREATED" DATE,
        "LAST_DDL_TIME" DATE,
        "TIMESTAMP" VARCHAR2(19),
        "STATUS" VARCHAR2(7),
        "TEMPORARY" VARCHAR2(1),
        "GENERATED" VARCHAR2(1),
        "SECONDARY" VARCHAR2(1)
   ) 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 "SYSTEM"
SQL>