oracle 手动增加序列值

1、select seq_name.nextval from dual; //假设得到结果5656 
2、alter sequence seq_name increment by -5655; //注意是-(n-1) 
3、select seq_name.nextval from dual;//再查一遍,走一下,重置为1了 
4、alter sequence seq_name increment by 1;//还原

posted on 2014-08-20 13:52  ︶ㄣ第二名  阅读(5287)  评论(0编辑  收藏  举报