– \uc720\uc77c(UNIQUE)\ud55c \uac12\uc744 \uc0dd\uc131\ud574\uc8fc\ub294 \uc624\ub77c\ud074 \uac1d\uccb4
\n– \uc2dc\ud000\uc2a4\ub97c \uc0dd\uc131\ud558\uba74 \uae30\ubcf8\ud0a4\uc640 \uac19\uc774 \uc21c\ucc28\uc801\uc73c\ub85c \uc99d\uac00\ud558\ub294 \uceec\ub7fc\uc744 \uc790\ub3d9\uc801\uc73c\ub85c \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4.
\n– \uc2dc\ud000\uc2a4\ub294 \ud14c\uc774\ube14\uacfc \ub3c5\ub9bd\uc801\uc73c\ub85c \uc800\uc7a5\ub418\uace0 \uc0dd\uc131\ub41c\ub2e4. \ub530\ub77c\uc11c \ud558\ub098\uc758 \uc2dc\ud000\uc2a4\ub97c \uc5ec\ub7ec \ud14c\uc774\ube14\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\uc2dc\ud000\uc2a4 \uc0dd\uc131 \ubb38\ubc95[Syntax]
\nCREATE SEQUENCE sequence_name
\n[START WITH n] — n\uc740 \uc2dc\ud000\uc2a4 \uc2dc\uc791 \uac12 \uc9c0\uc815
\n[INCREMENT BY n] — n\uc740 \uc2dc\ud000\uc2a4 \uc99d\uac00 \uac12 \uc9c0\uc815
\n[MAXVALUE n | NOMAXVALUE] — \uc2dc\ud000\uc2a4 \ucd5c\ub300\uac12, NOMAXVALUE\ub294 \ubb34\ud55c\ub300
\n[MINVALUE n | NOMINVALUE] — \uc2dc\ud000\uc2a4 \ucd5c\uc18c\uac12, NOMINVALUE\ub294 \ubb34\ud55c\ub300
\n[CYCLE | NOCYCLE]<\/p>\n
\uc2dc\ud000\uc2a4 \uc0dd\uc131\/\uc0ac\uc6a9 \uc608\uc81c
\nSQL>CREATE SEQUENCE emp_seq
\nSTART WITH 1
\nINCREMENT BY 1
\nMAXVALUE 100000;<\/p>\n
sequence created.<\/p>\n
— \uc2dc\uc791\uac12\uc774 1\uc774\uace0 1\uc529 \uc99d\uac00\ud558\uace0, \ucd5c\ub300\uac12\uc774 100,000\uc774 \ub418\ub294 \uc2dc\ud000\uc2a4\ub97c \uc0dd\uc131\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
SQL>INSERT INTO emp(empno, ename, hiredate) VALUE(emp_seq.NEXTVAL, ‘David’, sysdate);<\/p>\n
— empno\ub294 \uceec\ub7fc\uac12\uc744 \uc785\ub825\ud560 \ub54c \ub2e4\uc74c \uac12\uc744 \uae30\uc5b5\ud558\uc9c0 \uc54a\uc544\ub3c4 NEXTVAL\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc790\ub3d9\uc73c\ub85c \uc785\ub825\uc774 \ub41c\ub2e4.
\n— CURRVAL : \ud604\uc7ac\uac12 \ubc18\ud658 NEXTVAL : \ud604\uc7ac \uc2dc\ud000\uc2a4 \uac12\uc758 \ub2e4\uc74c\uac12 \ubc18\ud658<\/p>\n
SQL>SELECT emp_seq.CURRVAL FROM DUAL;<\/p>\n
CURRVAL
\n—————-
\n1<\/p>\n
SQL>SELECT emp_seq.NEXTVAL FROM DUAL;
\nNEXTVAL
\n—————–
\n2<\/p>\n
\uc2dc\ud000\uc2a4 \uc218\uc815\/\uc0ad\uc81c \ubb38\ubc95[Syntax]
\nALTER SEQUENCE sequence_name — START WITH\ub294 \uc218\uc815\ud560 \uc218 \uc5c6\ub2e4.
\n[INCREMENT BY n]
\n[MAXVALUE n | NOMAXVALUE]
\n[MINVALUE n | NOMINVALUE]
\n[CYCLE | NOCYCLE]<\/p>\n
\uc2dc\ud000\uc2a4 \uc218\uc815\/\uc0ad\uc81c \uc608\uc81c
\nSQL>ALTER SEQUENCE emp_seq
\nINCREMENT BY 2
\nCYCLE;<\/p>\n
sequence altered.<\/p>\n
— 2\uc529 \uc99d\uac00\ud558\uace0, \ucd5c\ub300\uac12\uc744 \ub118\uc73c\uba74 \ub2e4\uc2dc \ucc98\uc74c\uc73c\ub85c \uc21c\ud658\ud558\ub3c4\ub85d \uc218\uc815<\/p>\n
SQL>DROP SEQUENCE emp_seq<\/p>\n
sequence dropped.<\/p>\n