select 'alter sequence ' || t1.sequence_name || ' increment by 100000 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 100000 nocache;' from user_sequences t3
将Sequence统一加100000
最新推荐文章于 2022-09-06 13:57:45 发布