Re: value of last identity inserted

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 _at__at_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 - 22:15:38 CEST