DBMS_METADATA.GET_DDL (
object_type     IN VARCHAR2,
name            IN VARCHAR2,
schema          IN VARCHAR2 DEFAULT NULL,
version         IN VARCHAR2 DEFAULT 'COMPATIBLE',
model           IN VARCHAR2 DEFAULT 'ORACLE',
transform       IN VARCHAR2 DEFAULT 'DDL')
RETURN CLOB;

--можно прямо здесь указать версию
--не ниже  9.2.0
DBMS_METADATA.GET_DDL('TABLE','T','SCOTT','11.2.0')

set long 500000

select banner from v$version;

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production


create sequence test_seq;

--правильный совместимый вариант
--
select DBMS_METADATA.GET_DDL('SEQUENCE','TEST_SEQ','SCOTT','11.2.0') from dual;

  CREATE SEQUENCE  "SCOTT"."TEST_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;


--кривой с SESSION, PARTITION...
--
select DBMS_METADATA.GET_DDL('SEQUENCE','TEST_SEQ','SCOTT','17.2.0') from dual;

  CREATE SEQUENCE  "SCOTT"."TEST_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;

drop sequence test_seq;

SELECT  STYLESHEET FROM  SYS.METASTYLESHEET WHERE  (NAME='kuseq') AND (MODEL='ORACLE');
SELECT  STYLESHEET FROM  SYS.METASTYLESHEET WHERE  (NAME='kucommon') AND (MODEL='ORACLE');