current value of a sequence
407048Feb 7 2006 — edited Feb 8 2006Is there a way to get the current value of a sequence (other than saying a
select seq.nextval from dual and then, select seq.currval from dual). I just didn't want to bump up the sequence by saying nextval but needed to find the current value.
My sequence was created with options cache 20 , increment by 1