Hi,

I want to update one of the columns with the sum of 2 other columns on the same table.

I have written a trigger, which works fine with insert statements but on update, it's mutating. Whats the round about way of doing it.
Egs:
/******works fine************/
create or replace trigger t_nbn1
after insert on nbn1
begin
update nbn1
set c3 = c1 + c2;
end;
/*********************MUTATING PROBLEM****/
create or replace trigger tu_nbn1
after update on nbn1
for each row
begin
update nbn1
set c3 = c1 + c2;
end;
*************************************************
Badrinath