Re: value of last identity inserted

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sat, 05 Jun 2004 07:20:09 GMT
Message-ID: <Juewc.8885$Sw.8132@attbi_s51>

"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 Received on Sat Jun 05 2004 - 02:20:09 CDT