ORACLE 修改 SEQUENCE 增量值

備份常用語法~

--修改增量值為1000
ALTER SEQUENCE SCHEMA_NAME.SEQ_NAME INCREMENT BY 1000;

--取得下一個SEQ NUM
SELECT SCHEMA_NAME.SEQ_NAME.NEXTVAL FROM DUAL;

--恢復增量值為1
ALTER SEQUENCE SCHEMA_NAME.SEQ_NAME INCREMENT BY 1;

--確認增量值
SELECT SCHEMA_NAME.SEQ_NAME.CURRVAL FROM DUAL;

--提交
commit;

 

 Written By Felix Hsieh