1 select 'create sequence '||sequence_name||
2 ' minvalue '||min_value||
3 ' maxvalue '||max_value||
4 ' start with '||last_number||
5 ' increment by '||increment_by||
6 (case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'
7 from dba_sequences where sequence_owner='HC-BPMC-MANAGE'
2 ' minvalue '||min_value||
3 ' maxvalue '||max_value||
4 ' start with '||last_number||
5 ' increment by '||increment_by||
6 (case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'
7 from dba_sequences where sequence_owner='HC-BPMC-MANAGE'