Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER znizka
- before INSERT ON bilet FOR EACH ROW
- DECLARE
- znizka1 WIDZ.ZNIZKA%TYPE;
- BEGIN
- SELECT widz.ZNIZKA INTO znizka1 FROM widz,bilet WHERE :NEW.ID_WIDZ=widz.ID_WIDZ FETCH FIRST 1 ROW only;
- UPDATE widz SET ZNIZKA=znizka1+1 WHERE ID_WIDZ=:NEW.ID_WIDZ;
- END;
- /
- ALTER TRIGGER znizka ENABLE;
- SELECT znizka FROM widz WHERE id_widz=2;
- INSERT INTO BILET (ID_BILET,ID_WIDZ,ID_PRACOWNIKA,ID_SEANS,DATA_WYSTAWIENIA,STATUS) VALUES ('6','2','1','2',TO_DATE('18/02/06','RR/MM/DD'),'OK');
- SELECT znizka FROM widz WHERE id_widz=2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement