2014년 7월 18일 금요일

initialize oracle sequence

SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME = 'JUMIN_SEQ';

ALTER SEQUENCE JUMIN_SEQ INCREMENT BY -999998;

SELECT JUMIN_SEQ.NEXTVAL FROM DUAL;

ALTER SEQUENCE JUMIN_SEQ INCREMENT BY 1;

SELECT JUMIN_SEQ.NEXTVAL FROM DUAL;

댓글 없음: