oracle行触发器代码实例

oracle行触发器代码实例

create or replace trigger purorder_residue_quantity
after update of ftotalreceiptqty
on eas.t_sm_purorderentry 
for each row
begin
  update eas.t_sm_purorderentry set cfresidualquantity=fqty-ftotalreceiptqty   where  fid=:new.fid;
 end;