SQL |
---|
TRIGGER TRG_ESTADISTIQUES_P_J_B BEFORE INSERT ON ESTADISTIQUES_P_J for each row declare n number; begin /*n := :old.pt + :old.t1e + :old.t2e + :old.t3e + :old.rd + :old.ro + :old.ass + :old.tf + :old.pr - :old.t1i - :old.t2i - :old.t3i - :old.tc - :old.pp - :old.fc; :new.v := n; :new.vp := n * 10;*/ null; END; |