Hi lists,
DB:Oracle 8i
I need to write a db trigger on table T1. It has to update T2 when ever
T1 is updated.
(Both T1 and T2 tables have identical structure.)
The following query is doing wrong update.
can anybody tell me what is wrong in this code:
create or replace trigger trg_on_T1
The Where Clause Gives the rows...
create or replace trigger trg_on_T1
before update on T1
for each row
begin
if updating then
update T2
set a=:new.a,
b=:new.b,
c=:new.c
Where a=:old.a and b=:old.b and c=:old.c;
end if;
end trg_on_T1;
HTH
Best Regards,
Ganesh R
Tel :