Re: How to so select on sequence ?

From: Adam Warshaw <warsha-a_at_capital-re.com>
Date: 1996/09/18
Message-ID: <32407E42.4944_at_capital-re.com>#1/1


Shinu Gupta wrote:
>
> Hi:
>
> I am rather new to Oracle. I am currently using sequences for generating unique
> numbers. I am able to use seq.nextval and seq.currval successfully in insert
> and update statements.
>
> I want to do a select on the sequence, increment the value and save the value
> in a variable. The book says that I can do select on a sequence - but i can't
> figure out how.
>
> select nextVal from seq
>
> fails.
>
> Shinu Gupta

select seq.nextval from dual Received on Wed Sep 18 1996 - 00:00:00 CEST

Original text of this message