CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 MAXVALUE 100000;
INSERT INTO emp(empno, ename, hiredate ) VALUES
(emp_seq.NEXTVAL, 'julia' , sysdate);
SELECT emp_seq.CURRVAL FROM DUAL;
SELECT emp_seq.NEXTVAL FROM DUAL;
ALTER SEQUENCE emp_seq INCREMENT BY 2 CYCLE;
DROP SEQUENCE emp_seq;
'DB' 카테고리의 다른 글
using DAYS from DB2 (0) | 2013.10.20 |
---|