Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER tr_ustaw_kosz_wizyty
- before INSERT ON b2_wizyta
- FOR each ROW
- DECLARE
- v_typ VARCHAR2(20);
- BEGIN
- SELECT typ_pacjenta INTO v_typ FROM b2_pacjent WHERE kod_pacjenta = :NEW.kod_pacjenta;
- IF v_typ = 'nfz' THEN
- :NEW.koszt_wizyty := 0;
- END IF;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement