我这里有一个表,T_TEST,有4个字段,WID,ZT1,ZT2,ZT3.
我想要做就是当ZT3被更新成1时,ZT1、ZT2也自动更新成1.其他操作不管,谁能帮我写一个,我学习一下了。
------解决方案--------------------
create or replace trigger update_trigger
after update on T_TEST
REFERENCING new as new_val old as old_val
for each row
when (new_val.ZT3 = 1)
begin
update s set ZT1 = 1, ZT2 = 1 where WID = :old_val.WID;
end;