Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Getting current sequence value
Is there any way to get the current value of a sequence number without
incrementing it? You can't use currval unless you define the sequence
for the session by calling nextval first. Is there any way around this?