More easy way ?

Hi, All

  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;

It's could resolve the problem, but it's not perfect. 30 columns ...

 --
> > 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