Advertisement
Guest User

Untitled

a guest
Jun 10th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.37 KB | None | 0 0
  1. CREATE OR REPLACE TRIGGER trigger_towar
  2. BEFORE DELETE OR UPDATE OF stan, cena ON towar
  3. FOR EACH ROW
  4.   DECLARE
  5.  
  6.  
  7. BEGIN
  8.   IF UPDATING THEN
  9.     IF ((NEW:cena < 0) OR (NEW:stan <0)) THEN
  10.       RAISE_APPLICATION_ERROR(-20001, 'NIE MOŻNA ZMIENIAĆ CENY NA MNIEJSZA NIZ 1 ANI EDYTOWAC STANU');    
  11.     END IF;
  12.  
  13.   ELSIF DELETING THEN
  14.    
  15.  
  16.   END IF;
  17.  
  18. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement