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;

posted @ 2016-09-18 16:44  踏叶乘风  阅读(633)  评论(0编辑  收藏  举报