Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: current sequence value
To retrieve the current value from a sequence use mysequence.currval
---------------Next----------------------------- mysequence.nextval
Dharambir
Erik Forkalsrud wrote:
> Hi,
>
> I'm a newbie when it comes to Oracle, and I'm trying to move
> an MS SQL based application to Oracle 8.
>
> The MS SQL application uses the construct:
> INSERT INTO table_with_identity_column
> SELECT @@Identity
>
> I have figured out how to create a sequence object and a
> trigger to insert sequential values, but I haven't figured
> out how to retrieve the current value of a sequence object.
> Do sequence objects have other methods than mysequence.nextval
> (something like mysecquence.currentval) that I can use?
>
> Suggestions are appreciated.
>
> Erik Forkalsrud
Received on Fri Jan 15 1999 - 13:26:30 CST