1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set long 1000000000 longc 60000
SQL> Select dbms_metadata.get_ddl('SEQUENCE','EMPLOYEES_SEQ') seq
2 from dual
3 /
SEQ
--------------------------------------------------------------------------------
CREATE SEQUENCE "MNI"."EMPLOYEES_SEQ" MINVALUE 1 MAXVALUE 99999999999999999
9999999999 INCREMENT BY 1 START WITH 207 NOCACHE NOORDER NOCYCLE
SQL> |