Sequence 시퀀스 설정 관련 쿼리

create sequence SEQ_T_PRNTDOC

start with 1

increment by 1

MAXVALUE 100000;

DROP SEQUENCE SEQ_T_PRNTDOC;

 SELECT  LAST_NUMBER

 FROM    USER_SEQUENCES

 WHERE  SEQUENCE_NAME = 'SEQ_T_PRNTDOC';

 

SELECT SEQ_T_PRNTDOC.CURRVAL FROM DUAL;