Oracle SEQ(Sequence) 생성 / 삭제

1. Oracle Sequence 생성문

CREATE SEQUENCE [시퀀스명]
START WITH n
INCREMENT BY m
MAXVALUE x | NOMAXVALUE
MINVALUE y | NOMINVALUE

n : 초기화 값 (시작값)

m : 증가값

x : 최대값

y : 최소값

 

 

2. Sample ( 시퀀스명 : TEST_SEQ / 초기값 = 1 / 증가값 = 1 / 최대값 = 10000 )

create sequence TEST_SEQ
start with 1
increment by 1
maxvalue 10000
;

 

3. 삭제

DROP SEQUENCE [시퀀스명]