create or replace trigger t_name
after update of field of a
for each row
begin
update b set field=:new.field where...;
update c set field=:new.field where...;
end;
/
after update of field of a
for each row
begin
update b set field=:new.field where...;
update c set field=:new.field where...;
end;
/
bzszp(www.bzszp.533.net)的写法里不就有了吗?
:new.field就是a表里的字段!