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