Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER tr_inst_ew_il
- BEFORE INSERT OR UPDATE ON EWIDENCJA_ILOSCI
- FOR EACH ROW
- DECLARE v_cena numeric (8,2);
- BEGIN
- SELECT cena_produktu INTO v_cena FROM Produkt WHERE kod_produktu =:NEW.kod_produktu;
- :NEW.wartosc_produktu := :old.wartosc_produktu - :old.ilosc * v_cena + :NEW.ilosc * v_cena;
- UPDATE MAGAZYN
- SET wartosc_globalna = wartosc_globalna -:old.wartosc_produktu + :NEW.wartosc_produktu WHERE kod_magazynu = :NEW.kod_magazynu;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement