Copy the new row into another table... using Trigger
From: Chris <stvllium_at_ms18.hinet.net>
Date: 2000/08/07
Message-ID: <8mln40$56i_at_netnews.hinet.net>#1/1
end;
Date: 2000/08/07
Message-ID: <8mln40$56i_at_netnews.hinet.net>#1/1
Hi, All
How do I insert the new row (from NN, inserting) into another
table(NNCopy) in the trigger tgr1 ?
Create or replace trigger tgr1
After insert on NN
For each row
begin
insert into NNCopy
?????????????????????
end;
Table NN and NNCopy have the same table definition, there have about 30 columns in NN.
Thanks
Chris Chi from Taiwan, R.O.C. Received on Mon Aug 07 2000 - 00:00:00 CEST