抽取sequence的创造语句

抽取sequence的创建语句

?

?

select  'create sequence ' ||sequence_name||           ' minvalue ' ||min_value||           ' maxvalue ' ||max_value||           ' start with ' ||last_number||           ' increment by ' ||increment_by||          ( case  when cache_size= 0  then  ' nocache'   else   ' cache ' ||cache_size end) || ';'   from user_sequences;