Re: Oracles @@Identity?
From: David Browne (meat_at_hotmail.com)
Date: 02/01/05
- Next message: AMerrell: "Re: ADO.NET and Sleeping processes"
- Previous message: David Browne: "Re: Oracle vs SqlServer parameters"
- In reply to: SDF: "Oracles @@Identity?"
- Next in thread: SDF: "Re: Oracles @@Identity?"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: AMerrell: "Re: ADO.NET and Sleeping processes"
- Previous message: David Browne: "Re: Oracle vs SqlServer parameters"
- In reply to: SDF: "Oracles @@Identity?"
- Next in thread: SDF: "Re: Oracles @@Identity?"
- Messages sorted by: [ date ] [ thread ]