RE: trigger question

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <thump@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 23 Nov 2004 17:47:14 -0500

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

Other related posts: