Oracle DBA and beyond; these are practical tips for day to day DBA operation and maintenance; a place where you would come to look for a quick fix for a burning situation. I hope that by sharing all these, we all will become better in what we do. And on the way, I hope to save you some sweat :-)
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.
No comments:
Post a Comment