Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER tr_INS_fak_det
- before INSERT ON FAKTURA_DETALE
- FOR each ROW
- DECLARE nowa_cena numeric(6,2);
- BEGIN
- SELECT cena INTO nowa_cena FROM KOMIKS WHERE id_komiksu = :NEW.id_komiksu;
- :NEW.cena_zakupu := nowa_cena;
- UPDATE FAKTURA_NAGLOWEK
- SET wartosc_faktury=(:NEW.liczba*:NEW.cena_zakupu) + wartosc_faktury WHERE id_faktury = :NEW.ID_FAKTURY;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement