Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE "A_test" 
(   "ID" NUMBER, 
"NAME" VARCHAR2(90 BYTE), 
"ADDRESS" VARCHAR2(90 BYTE), 
"GENDER" CHAR(1 BYTE)
) 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)
SELECT DBMS_METADATA.GET_DDL( 'TABLE', 'A_test', USER ) AS ddl
FROM   DUAL;


DDL



  CREATE TABLE "FIDDLE_RGGUSDZQFAPEKUFYLHGN"."A_test" 
   ( "ID" NUMBER, 
 "NAME" VARCHAR2(90), 
 "ADDRESS" VARCHAR2(90), 
 "GENDER" CHAR(1)
   ) 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 "USERS"


BEGIN
  DBMS_METADATA.set_transform_param(
    DBMS_METADATA.session_transform,
    'SQLTERMINATOR',
    TRUE
  );
  DBMS_METADATA.set_transform_param(
    DBMS_METADATA.session_transform,
    'PRETTY',
    FALSE
  );
  DBMS_METADATA.set_transform_param(
    DBMS_METADATA.session_transform,
    'SEGMENT_ATTRIBUTES',
    FALSE
  );
  DBMS_METADATA.set_transform_param(
    DBMS_METADATA.session_transform,
    'STORAGE',
    FALSE
  );
END;
/
1 rows affected

SELECT DBMS_METADATA.GET_DDL( 'TABLE', 'A_test', USER ) AS ddl
FROM   DUAL;


DDL



  CREATE TABLE "FIDDLE_RGGUSDZQFAPEKUFYLHGN"."A_test" ("ID" NUMBER, "NAME" VARCHAR2(90), "ADDRESS" VARCHAR2(90), "GENDER" CHAR(1)) ;


DECLARE
  v_sql CLOB;
BEGIN
  DBMS_METADATA.set_transform_param(
    DBMS_METADATA.session_transform,
    'SQLTERMINATOR',
    TRUE
  );
  DBMS_METADATA.set_transform_param(
    DBMS_METADATA.session_transform,
    'PRETTY',
    FALSE
  );
  DBMS_METADATA.set_transform_param(
    DBMS_METADATA.session_transform,
    'SEGMENT_ATTRIBUTES',
    FALSE
  );
  DBMS_METADATA.set_transform_param(
    DBMS_METADATA.session_transform,
    'STORAGE',
    FALSE
  );
  SELECT DBMS_METADATA.GET_DDL( 'TABLE', 'A_test', USER )
  INTO   v_sql
  FROM   DUAL;

  DBMS_OUTPUT.PUT_LINE(v_sql);
END;
/
1 rows affected

dbms_output:

  CREATE TABLE "FIDDLE_RGGUSDZQFAPEKUFYLHGN"."A_test" ("ID" NUMBER, "NAME" VARCHAR2(90), "ADDRESS" VARCHAR2(90), "GENDER" CHAR(1)) ;