Re: sequences

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 9 May 2001 09:44:12 +0200
Message-ID: <tfht6bkcp52of4@beta-news.demon.nl>

"Tim" <tim_at_nospam.aiinet.com> wrote in message news:gR_J6.77$DP.1441_at_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
> >
> >
>
>

I'm not sure about that. My reply is listed at 8-5-00 21:05 and your reply at 09-05 00:58.
You did wait for 4 hours with posting your reply to yourself?

Regards,

Sybrand Bakker Received on Wed May 09 2001 - 02:44:12 CDT