CREATE OR REPLACE TRIGGER SalaryRestriction BEFORE INSERT ON professor FOR EACH ROW
BEGIN
  IF (:new.salary < 70000)
    THEN RAISE_APPLICATION_ERROR (-20004, 'Violation of Minimum Salary constraint');
  END IF;
END;
.
run;
