오라클 시퀀스 생성하기

CREATE SEQUENCE [시퀀스명]

  START WITH 1

  MAXVALUE 9999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  CACHE 20

  NOORDER;

[시퀀스명].nextval

시퀀스조회

SELECT SEQUENCE_NAME, MIN_VALUE, MAX_VALUE, INCREMENT_BY, CYCLE_FLAG 

FROM USER_SEQUENCES;

해당시퀀스삭제

  DROP SEQUENCE [시퀀스명];