Re: value of last identity inserted
Date: Sat, 05 Jun 2004 07:20:09 GMT
Message-ID: <Juewc.8885$Sw.8132_at_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
> _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