Re: value of last identity inserted

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 07 Jun 2004 20:37:33 +0200
Message-ID: <ca2cd2$12e$2_at_news3.tilbu1.nb.home.nl>

Jim Kennedy wrote:

> "Carlos San Miguel" <yatuchabe_at_hotmail.com> wrote in message
> news:b5abf2cd.0406041215.50375a1f_at_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
>>_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

>
>
> Look up the returning clause in the select statement.
> Jim
>
>
And sequences, and the combination with a trigger

-- 

Regards,
Frank van Bortel

Received on Mon Jun 07 2004 - 20:37:33 CEST