From saurabhs@fcsltd.com Thu, 22 Feb 2001 22:29:01 -0800 From: "Saurabh Sharma" Date: Thu, 22 Feb 2001 22:29:01 -0800 Subject: Re: HOW TO SELECT LATEST INSERTED ROW.. Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 SenguptaExecutive SystemsUsha Martin Telekom Ltd.11 Dr. U N Bhramchari Road.Calcutta - 700017Cell Phone: + 91 98300 32780Email : ranasengupta@umtl.co.inWeb: www.commandcell.com
----- Original Message -----