シーケンスのコピー

copy_sequence.sql

-- Thanks https://community.oracle.com/thread/630462?start=0&tstart=0
select 'Create Sequence '||sequence_name||
       ' increment by '||increment_by||
       ' start with '||last_number||
       ' maxvalue '||max_value||
       decode(cycle_flag,'N',' NOCYCLE ',' CYCLE ')||
       decode(cache_size,0,'NOCACHE ','CACHE '||cache_size)
from user_sequences;