Re: Copy the new row into another table... using Trigger
Date: 2000/08/07
Message-ID: <8mlrn3$34q$1_at_s1.read.news.oleane.net>#1/1
Create or replace trigger tgr1
After insert on NN
For each row
begin
insert into NNCopy (col1, col2, ...)
values (:new.col1, :new.col2, ...);
end;
/
--
Have a nice day
Michel
Chris <stvllium_at_ms18.hinet.net> a écrit dans le message : 8mln40$56i_at_netnews.hinet.net...
> 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