Oracle 修改 SEQUENCE

修改INCREMENT(可以為負)，再執行NEXTVAL

ALTER SEQUENCE seq INCREMENT BY 100;
SELECT seq.NEXTVAL FROM DUAL;

執行完記得改回1

ALTER SEQUENCE seq INCREMENT BY 1;