Re: Copy the new row into another table... using Trigger

Is there have any easily way ? Cause NN have 30 columns.

Michel Cadot <micadot_at_netcourrier.com> wrote in message news:8mlrn3$34q$1_at_s1.read.news.oleane.net...
> 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