시퀀스 추출

시퀀스 스크립트 추출 sql 문 

SELECT 'create sequence ' || SEQUENCE_NAME
       || ' start with '      ||GREATEST(MIN_VALUE,LAST_NUMBER)
       || ' increment by '    ||INCREMENT_BY
       || ' minvalue '        ||MIN_VALUE
       || ' maxvalue '        ||MAX_VALUE
       ||DECODE(CACHE_SIZE, 0, ' nocache', ' cache ' || CACHE_SIZE)      
       || ' '||DECODE(CYCLE_FLAG, 'Y', 'cycle', 'nocycle')
       || ' '||DECODE(ORDER_FLAG, 'Y', 'order', 'noorder') ||';'
  FROM DBA_SEQUENCES
 WHERE SEQUENCE_OWNER = 'SCOTT';