Re: How get the current value from a sequence?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 2 Dec 2004 16:45:39 -0600
Message-ID: <u3byoxsm4.fsf@standardandpoors.com>

On Fri, 3 Dec 2004, crb_at_amsa.gov.au wrote:
> Hi all
>
> DA Morgan wrote in response to

>> > whats wrong with select seq_name.nextval fom dual?

>

>>One big thing ... that being you just took another number off
>>the top of the sequence.

>
> I believe that executing the command select seq_name.nextval
> from dual; does not increment the sequence (the first
> time), but defines the sequence for the session.

Oh yes it does.

-- 
Galen Boyer

Received on Thu Dec 02 2004 - 16:45:39 CST