日期:2014-05-16 浏览次数:20567 次
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;