Advertisement
rejcsibejcsi

asd

May 21st, 2023
1,952
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.22 KB | None | 0 0
  1. CREATE OR REPLACE TRIGGER constraint_trigger
  2.   BEFORE INSERT ON reviews
  3.   FOR EACH ROW
  4. BEGIN
  5.    IF :NEW.rating > 10 THEN
  6.       RAISE_APPLICATION_ERROR(-20000, 'Rating cannot be higher than 10');
  7.    END IF;
  8. END;
  9.  
  10.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement