1.查询序列的下一个值:
SELECT SEQ_NAME.NEXTVAL FROM dual;
2.如果想修改序列的下个值:
alter sequence SEQ_NAME increment BY X; ----X为正数负数都可以
3.查询序列的下一个值:
SELECT SEQ_NAME.NEXTVAL FROM dual; --查看是否修改成功
4.重新将序列的值的增长值设为1
alter sequence SEQ_NAME increment BY 1;