Sequence current value and next value : Sequence Value « Sequence « Oracle PL / SQL





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>
           
         
  










Related examples in the same category

1.Use sequence in insert command
2.Get Sequence next value
3.Sequence max value: 999999999999999999999999999
4.Set sequence max value
5.Use Sequence in a procedure
6.If new value is null use the value from a sequence
7.Automatically including unique sequence numbers during an INSERT.
8.Random value based on sequence