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
>>@@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 - 13:37:33 CDT
