17,086
社区成员
发帖
与我相关
我的任务
分享
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;