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_at_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_at_fatcity.com"
title=ORACLE-L_at_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
Received on Wed Feb 21 2001 - 06:18:22 CST
