From ranasengupta@umtl.co.in Wed, 21 Feb 2001 04:18:22 -0800
From: "Rana Sengupta" <ranasengupta@umtl.co.in>
Date: Wed, 21 Feb 2001 04:18:22 -0800
Subject: Re: HOW TO SELECT LATEST INSERTED ROW..
Message-ID: <F001.002B95DF.20010221034522@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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 
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Saurabh 
  Sharma 
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>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.
  <FONT face="Comic Sans MS" 
size=2>saurabh