Re: value of last identity inserted

From: Carlos San Miguel <yatuchabe_at_hotmail.com>
Date: 4 Jun 2004 13:15:38 -0700
Message-ID: <b5abf2cd.0406041215.50375a1f@posting.google.com>

I'm actually trying to get the last serial number assigned to a row inserted by the current session. With MSSQL you can get it with select @@IDENTITY, with INformix you can use SELECT DBINFO('sqlca.sqlerrd1') FROM systables where tabid = 1;
How can I do the same with Oracle?

TIA
Carlos San Miguel

yatuchabe_at_hotmail.com (Carlos San Miguel) wrote in message news:<b5abf2cd.0406031701.58d3b016_at_posting.google.com>...
> Hi, I'm going to be using Oracle with a customer. I will access
> Oracle with ODBC. All the tables have an Identity column, this is the
> ID for the record. I need to know how I can get the value of the
> Identity column for the last record inserted. A stored procedure maybe?
>
> TIA
> Carlos San Miguel
Received on Fri Jun 04 2004 - 15:15:38 CDT