DB/Oracle
SEQUENCE 값 재 설정
Lohen
2016. 2. 4. 23:36
increment by 로 9999 지정하고 nextval한후 increment by 를 다시 1
alter sequence SCOTT.SEQ_EMP increment by 9999;
select SCOTT.SEQ_EMP.nextval from dual;
alter sequence SCOTT.SEQ_EMP increment by 1;
반응형