Hi,
I'm trying to create a after update trigger on a table for two columns with "or" condition. Its not allowing me to create like that. Is there any can I do?
drop table t1;
create table t1( a number,b number);
drop table t2;
create table t2( c number);
create or replace
trigger trg_t1
after update of (a or b)
on t2
for each row when (new.a is not null or new.b is not null)
declare
begin
if :old.a:new.a
then
update t2 set c=a;
end if ;
if :old.b:new.b
then
update t2 set c=b;
end if ;
end;
In advance thanks a lot.
Regards,
vg.