Oracle 21c

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 SEQUENCE "appointment_id";
create table "appointments"
       (
        "appointment_id" number(12,0)                   default "appointment_id".nextval,
        "appointment_title" varchar2(50 byte),
        "appointment_priority"                          number generated always as (1) virtual
       ) ;
SELECT dbms_metadata.get_ddl(
          'TABLE',
          'appointments',
          USER
       )
FROM   DUAL;


DBMS_METADATA.GET_DDL('TABLE','APPOINTMENTS',USER)



  CREATE TABLE "FIDDLE_NRWJUYYFWNVZWWFDXLMA"."appointments" 
   (	"appointment_id" NUMBER(12,0) DEFAULT "FIDDLE_NRWJUYYFWNVZWWFDXLMA"."appointment_id"."NEXTVAL", 
	"appointment_title" VARCHAR2(50), 
	"appointment_priority" NUMBER GENERATED ALWAYS AS (1) VIRTUAL 
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "USERS"


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

SELECT dbms_metadata.get_ddl(
          'TABLE',
          'appointments',
          USER
       )
FROM   DUAL;


DBMS_METADATA.GET_DDL('TABLE','APPOINTMENTS',USER)



  CREATE TABLE "FIDDLE_NRWJUYYFWNVZWWFDXLMA"."appointments" 
   (	"appointment_id" NUMBER(12,0) DEFAULT "FIDDLE_NRWJUYYFWNVZWWFDXLMA"."appointment_id"."NEXTVAL", 
	"appointment_title" VARCHAR2(50), 
	"appointment_priority" NUMBER GENERATED ALWAYS AS (1) VIRTUAL 
   ) ;