Re: value of last identity inserted

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 04 Jun 2004 04:10:53 GMT
Message-ID: <hDSvc.42206$eY2.25236@attbi_s02>

"Carlos San Miguel" <yatuchabe_at_hotmail.com> 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

select? How about the max number if it really is monotonically increasing. Are you asking how to write a select statement? Jim Received on Thu Jun 03 2004 - 23:10:53 CDT