`
lxy2330
  • 浏览: 460125 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

批量修改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;

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics