Re: HOW TO SELECT LATEST INSERTED ROW..

[Saurabh Sharma]

thanks rana sengupta. it worked. but it is actually working fine whileinserting 1 row at a time. i tried to write with row level trigger. but both should be statement level triggers. else giving errors like. table is  mutataing, trigger/function can't see it..etc.   thanks again.   saurabh ----- Original Message ----- From: Rana Sengupta To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 21, 2001 5:15 PM Subject: Re: HOW TO SELECT LATEST INSERTED ROW.. Hay, U can proceed in following way.......... create a dummy table having one row one column ;  Update this value in a row level insert trigger of your concrn table by the current row id ( or any key ). Next use a statement level insert trigger on that concern table and by select that key from dummy table U and perform the  required opr.   This Row-level & Statement level triggers will be usefull only when U inserting 1 row at a time. Regards  Rana Sengupta Executive Systems Usha Martin Telekom Ltd. 11 Dr. U N Bhramchari Road. Calcutta - 700017 Cell Phone: + 91 98300 32780 Email : [EMAIL PROTECTED] Web: www.commandcell.com ----- Original Message ----- From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 21, 2001 3:45 PM Subject: HOW TO SELECT LATEST INSERTED ROW.. HI ALL, how can i select the latest inserted row from a table. i want to select a col value, perform some operation on it and update the same to table via a trigger.. it says table is mutating. i'm inserting rows 1 at a time.   any suggestions.. thanks in advance. saurabh