[oracle] sequence

 

CREATE SEQUENCE TEST_SEQ
START WITH 1
INCREMENT BY 1
NOMINVALUE
NOMAXVALUE
NOCACHE
NOCYCLE
;

DROP SEQUENCE TEST_SEQ
;

SELECT TEST_SEQ.NEXTVAL
FROM DUAL
;

SELECT TEST_SEQ.CURRVAL
FROM DUAL
;

ALTER SEQUENCE TEST_SEQ
INCREMENT BY 2
;