Re: sequences

From: Tim <tim_at_nospam.aiinet.com>
Date: Tue, 8 May 2001 18:58:50 -0400
Message-ID: <gR_J6.77$DP.1441@client>

Hehe, I actually solved this one before anyone replied. For those wanting to know the solution here it is. You just use a select statement like the following against the "dual" table, which is just a dummy table.

select tim_seq.nextval from dual;

That will give you the next value of the sequence as well as incrementing it.

Tim

Tim wrote in message <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
>
>
Received on Tue May 08 2001 - 17:58:50 CDT