 |
| 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>
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>
