Monday 6 May 2019

How to check the current value of the sequence, without advancing it?

SQL> select MY_SEQ.currval from dual;

   CURRVAL
----------
         1

currval, as opposed to nextval, is not advancing the sequence.