From: kennedy-downwithspammersfamily@attbi.net   
      
   "Carlos San Miguel"  wrote in message   
   news:b5abf2cd.0406041215.50375a1f@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@hotmail.com (Carlos San Miguel) wrote in message   
   news:...   
   > > 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)