current sequence value

From: Erik Forkalsrud <erik_at_acim.com>
Date: Wed, 13 Jan 1999 12:41:23 -0800
Message-ID: <369D04F2.973C5399@acim.com>

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 Wed Jan 13 1999 - 14:41:23 CST