Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER saldo_financeiro
- AFTER UPDATE OF valorPat
- ON patrocinio
- FOR EACH ROW
- BEGIN
- UPDATE patrocinio SET saldoPat = saldoPat + ( :new.valorPat - :old.valorPat ) WHERE numEd = :new.numEd AND codEv = :new.codEv;
- UPDATE edicao SET saldoFinanceiroEd = saldoFinanceiroEd + ( :new.valorPat - :old.valorPat ) WHERE numEd = :new.numEd AND codEv = :new.codEv;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement