读书人

抽取sequence的创造语句

发布时间: 2012-12-15 15:16:03 作者: rapoo

抽取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;
?

读书人网 >其他数据库

热点推荐