首页 > 技术文章 > ORACLE 重置SEQQUENCE

champaign 2016-09-18 16:44 原文

 

  select seq.nextval from dual; --假设值是30

  alter sequence seq increment by -30;

  select seq.nextval from dual; --会得到0

  alter sequence seq increment by 1;

推荐阅读