Re: Oracles @@Identity?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David Browne (meat_at_hotmail.com)
Date: 02/01/05


Date: Tue, 1 Feb 2005 14:02:39 -0600


"SDF" <sdf@nospam.com> wrote in message
news:OONT5RJCFHA.2380@tk2msftngp13.phx.gbl...
> Is there an equivalent? I have a sequence set up to create me a unique
> ID,
> but I need to return that too!
>

The most direct equivilent is my_sequence.currval. This will return the
last my_sequence.nextval that your session retrieved.

David