ORACLE 重置SEQQUENCE

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

  alter sequence seq increment by -30;

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

  alter sequence seq increment by 1;

原文地址:https://www.cnblogs.com/champaign/p/5882161.html