SELECT ' CREATE SEQUENCE '||SEQUENCE_NAME|| ' INCREMENT BY '||
INCREMENT_BY ||' START WITH '||LAST_NUMBER||' MAXVALUE '||
MAX_VALUE ||' CACHE '||CACHE_SIZE||' ORDER NOCYCLE ;'
FROM user_SEQUENCES;
eg:
CREATE SEQUENCE TBAPPLYPUBLICSEQ INCREMENT BY 1 START WITH 61 MAXVALUE 999999999999999999999999999 CACHE 20 ORDER NOCYCLE ;