Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER tr_UPD_fak_nag
- before UPDATE ON FAKTURA_DETALE
- FOR each ROW
- BEGIN
- UPDATE FAKTURA_NAGLOWEK
- SET wartosc_faktury = wartosc_faktury-(:old.cena_zakupu*:old.liczba)+(:NEW.cena_zakupu*:NEW.liczba) WHERE id_faktury =:NEW.id_faktury;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement