Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER trigger_towar
- BEFORE DELETE OR UPDATE OF stan, cena ON towar
- FOR EACH ROW
- DECLARE
- BEGIN
- IF UPDATING THEN
- IF ((NEW:cena < 0) OR (NEW:stan <0)) THEN
- RAISE_APPLICATION_ERROR(-20001, 'NIE MOŻNA ZMIENIAĆ CENY NA MNIEJSZA NIZ 1 ANI EDYTOWAC STANU');
- END IF;
- ELSIF DELETING THEN
- END IF;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement