WEB TIP/Oracle

SEQUENCE 생성

제프 2006. 4. 13. 11:51

출처 : 오라클클럽

CREATE SEQUENCE sequence_name
[START WITH n]
[INCREMENT BY n]
[MAXVALUE n | NOMAXVALUE]
[MINVALUE n | NOMINVALUE]
[CYCLE | NOCYCLE]

예문)
CREATE SEQUENCE seq
START WITH 1
INCREMENT BY 1
MAXVALUE 100
→ 초기값 1, 증가값 1, 최대값 100