====== 오라클 SEQUENCES ======
 
===== CREATE =====
<code sql>
CREATE SEQUENCE SEQ_USER_NO
         START WITH 10001
         INCREMENT BY 1
         MAXVALUE  1E28
         MINVALUE  1
         NOCYCLE
         CACHE  20
         NOORDER;
</code>

===== DROP =====
<code sql>
DROP SEQUENCE SEQ_USER_NO;
</code>

===== NUMBER CHANGE =====
  - 시퀀스 증가단위와 시퀀스번호를 확인 <code sql>select SEQUENCE_NAME,INCREMENT_BY,LAST_NUMBER 
from user_sequences 
where sequence_name='SEQ_USER_NO'; </code>
  - 시퀀스 증가범위를 1000단위로 변경 <code sql>ALTER SEQUENCE SEQ_USER_NO INCREMENT BY 1000;</code>
  - 시퀀스 증가 <code ql>SELECT SEQ_X.NEXTVAL FROM DUAL;</code>
  - 시퀀스를 원래 증가단위를 1단위로 변경 <code sql>ALTER SEQUENCE SEQ_USER_NO INCREMENT BY 1;</code>