Method 1:
SELECT 'create SEQUENCE '| SEQUENCE_NAME | 'crement BY' |
INCREMENT_BY | 'start with' | LAST_NUMBER | 'maxvalue' |
MAX_VALUE | 'cache' | CACHE_SIZE | 'order NOCYCLE ;'
FROM user_SEQUENCES;
The result is similar:
Create sequence ARTCOMMENT_SEQ increment by 1 start with 341 MAXVALUE 999999999999999999999999999 CACHE 20 order nocycle;
Create sequence ARTICLEVISTCECOLLECT_SEQ increment by 1 start with 1 MAXVALUE 999999999999999999999999999 CACHE 20 order nocycle;
Create sequence ARTICLEVISTTEMP_SEQ increment by 1 start with 82989 MAXVALUE 999999999999999999999999999 CACHE 20 order nocycle;
Create sequence ARTICLEVIST_SEQ increment by 1 start with 1675 MAXVALUE 999999999999999999999999999 CACHE 20 order nocycle;
Create sequence ARTICLE_SEQ increment by 1 start with 1908 MAXVALUE 999999999999999999999999999 CACHE 20 order nocycle;
Method 2:
Select dbms_metadata.get_ddl ('sequence ', u. object_name) from user_objects u where object_type = 'sequence'
The result is similar:
Create sequence "MO_VO". "ARTCOMMENT_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 increment by 1 start with 341 CACHE 20 order nocycle;
Create sequence "MO_VO". "ARTICLEVISTCECOLLECT_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 increment by 1 start with 1 CACHE 20 order nocycle;
Create sequence "MO_VO". "ARTICLEVISTTEMP_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 increment by 1 start with 82989 CACHE 20 order nocycle;
Create sequence "MO_VO". "ARTICLEVIST_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 increment by 1 start with 1675 CACHE 20 order nocycle;