------解决方案-------------------- 触发器这么写 if :Old.字段名<>:new.字段名 then Insert into B ..... end if
------解决方案--------------------
------解决方案-------------------- create or replace trigger update_a after update on A for each row when (old.x!=new.x or old.y!=new.y or old.z!=new.z) declare begin insert into b values (:new.x,:new.y,:new.z); end;