修改序列值
使用循环执行
1 | select 序列.nextval from DUAL; |
设置步长值
设置步长值
1
ALTER SEQUENCE PERSON_SEQ INCREMENT BY 100;
跳转
1
select PERSON_SEQ.nextval from DUAL;
改回来
1
ALTER SEQUENCE PERSON_SEQ INCREMENT BY 1;
本博客所有文章除特别声明外，均采用 CC BY-NC-SA 4.0 许可协议。转载请注明来自 AlMirai！
1 | select 序列.nextval from DUAL; |
设置步长值
1 | ALTER SEQUENCE PERSON_SEQ INCREMENT BY 100; |
跳转
1 | select PERSON_SEQ.nextval from DUAL; |
改回来
1 | ALTER SEQUENCE PERSON_SEQ INCREMENT BY 1; |
