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 );
INSERT INTO AA VALUES ( AA_SEQ.NEXTVAL );