Delete Triggers

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 Received on Wed Jan 12 2000 - 14:56:20 CST