์ํ์ค ์ด๊ธฐํํ๊ธฐ --1.ํ์ฌ ์ํ์ค๊ฐ ํ์ธ SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME = '์ํ์ค๋ช ' --2.ํ์ฌ ์ํ์ค์ INCREMENT๋ฅผ ํ์ฌ ๊ฐ ๋งํผ ์ฐจ๊ฐ ALTER SEQUENCE ์ํ์ค๋ช INCREMENT BY -ํ์ฌ์ํ์ค; ex) : 1๋ฒ ์ํํ ํ์ธ๊ฒฐ๊ณผ ํ์ฌ์ํ์ค๊ฐ 10์ผ๋ ALTER SEQUENCE ์ํ์ค๋ช INCREMENT BY -10; --3.์ํ์ค์ ๋ค์ ๊ฐ ์คํ SELECT ์ํ์ค๋ช .NEXTVAL FROM DUAL --4.ํ์ฌ์ํ์ค๊ฐ ์กฐํ SELECT ์ํ์ค๋ช .CURRVAL FROM DUAL --5. ์ํ์ค์ INCREMENT ๋ฅผ 1๋ก ์ค์ ALTER SEQUENCE ์ํ์ค๋ช INCREMENT BY 1;