读书人

批量批改SEQUENCE,序列同时增加10000

发布时间: 2012-07-26 12:01:08 作者: rapoo

批量修改SEQUENCE,序列同时增加10000

select 'alter sequence ' || t1.sequence_name ||
?????? ' increment by 10000 nocache;'
? from user_sequences t1
union all
select 'select ' || t2.sequence_name || '.nextval from dual;'
? from user_sequences t2
union all
select ' alter sequence ' || t3.sequence_name ||
?????? ' increment by 1 CACHE 20;'
? from user_sequences t3;

读书人网 >其他数据库

热点推荐