Mega Code Archive

 

Categories / Oracle PLSQL / Sequence

 

Sequence current value and next value

SQL> SQL> -- It is important to note that the value of CURRVAL is not populated until  after NEXTVAL has been used. SQL> SQL> SQL> CREATE SEQUENCE StudentNumSeq   2    INCREMENT BY 1   3    START WITH 1100   4    MAXVALUE 99999   5    NOCACHE   6    NOCYCLE; Sequence created. SQL> SQL> SQL> select StudentNumSeq.NEXTVAL from DUAL;                  NEXTVAL ------------------------                  1100.00 SQL> SQL> SQL> SELECT StudentNumSeq.CURRVAL FROM DUAL;                  CURRVAL ------------------------                  1100.00 SQL> SQL> SQL> drop sequence StudentNumSeq; Sequence dropped. SQL> SQL>