| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete Triggers
This insert command is always the same.
Your can do the following:
insert into tmp_a (field1,field2) values ("contentf1","contentf2");
cheefook wrote:
> Hi Oracle Expert,
>
> I am trying to create several delete triggers for numbers of tables.
>
> create or replace trigger table_tmp_a_trig before delete on table_a for
> each row
> begin
> insert into tmp_a values(col a, col b, col c.......); /* table has
> 40 columns)
> end;
>
> Is there an easy way to implement this trigger without specify all columns
> in insert into tmp_a values(....)?
>
> i.e insert a row into table a as a row is deleted.
>
> The goal is to move all deleted rows from table A to table B.
>
> Or there is a better way to achieve it.
>
> FYI,
> Oracle Server : 7.3.2.1.0
>
> Thanks for your help.
>
> chai
--
 |
 |