Re: sequences

"Tim" <tim_at_nospam.aiinet.com> wrote in message news:60XJ6.44$DP.832_at_client...
> Is there any way to get the current value of a sequence, from a sqlplus
> prompt, without using the sequence in an insert or select statement?
>
>
> Tim Troester
>
>

select sequence.currval
from dual;

You should have used sequence.nextval at least once in your session, or this won't work.

Doc question.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue May 08 2001 - 14:05:17 CDT