RE: trigger question

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 23 Nov 2004 17:47:14 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9C09@AABO-EXCHANGE02.bos.il.pqe>

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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David
> Sent: Tuesday, November 23, 2004 2:11 PM
> To: oracle-l_at_freelists.org
> 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

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 23 2004 - 19:31:35 CST