create or replace trigger back_up_the_data before update on data_table for each row begin insert into backup_table values(:old.col_a,:old.col_b,:old.col_c,...); end; / That ought to do it..... Whoops, just saw your updated mail....in that case, try: create or replace trigger make_a_copy before insert on data_table for each row begin insert into copy_table values(:new.col_a,:new.col_b,:new.col_c,...); end; / Try that, -Mark > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David > Sent: Tuesday, November 23, 2004 2:11 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: trigger question >=20 >=20 > How can I create a trigger that backs up the row that is updated on a > table to a backup table pleasE? > --=20 > .. > David >=20 > -- > //www.freelists.org/webpage/oracle-l >=20 -- //www.freelists.org/webpage/oracle-l