Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --wyzwalacz zabraniajacy zmieniania typu auta
- CREATE OR REPLACE TRIGGER zab_usuw
- BEFORE DELETE OR UPDATE ON typ_auta
- BEGIN
- IF DELETING THEN RAISE_APPLICATION_ERROR(-20501,'Nie usuwaj!');
- ELSE RAISE_APPLICATION_ERROR(-20501,'Zakaz modyfikowania');
- END IF;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement