From: fvanbortel@netscape.net   
      
   Jim Kennedy wrote:   
      
   > "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   
   >   
   >   
   And sequences, and the combination with a trigger   
      
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)