oracle 手动增加序列值
时间:2022-03-13 22:53
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;//还原
oracle 手动增加序列值,布布扣,bubuko.com