IT/Oracle

오라클 ORACLE 시퀀스 SEQUENCE

노마드오브 2018. 7. 23. 22:40
CREATE SEQUENCE AA_SEQ START WITH 1 INCREMENT BY 1;

SELECT AA_SEQ.NEXTVAL FROM DUAL;

INSERT INTO AA VALUES ( AA_SEQ.NEXTVAL );