Generate scrip using dbms_metadata.get_ddl in ORACLE

select dbms_metadata.get_ddl('OBJECT_TYPE','OBJECT_NAME','OWNER') a from dual

ex.

:TYPE TABLE

select dbms_metadata.get_ddl('TABLE','PMS_ACADEVALSTAFFWORKPUB','HRIS') a from dual

:TYPE CONRAINTS

SQL> set linesize 200
SQL> col c format a100
SQL>set long 9999
SQL> select dbms_metadata.get_ddl('CONSTRAINT', 'PK_APP_POSTAPPLICANTTOPIC','HRIS') c from dual;

C
--------------------------------------------------------------------------------

  ALTER TABLE "HRIS"."APP_POSTAPPLICANTTOPIC" ADD CONSTRAINT "PK_APP_POSTAPPLICANTTOPIC" PRIMARY KEY ("ID")
  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 "USERS"  ENABLE