title: Why is this Oracle SQL code failing (using trigger that restricts salary)
body: <p>I need help with this:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER restrict_salary BEFORE
    INSERT OR
    UPDATE OF max_salary ON employees
    FOR EACH ROW BEGIN IF :NEW.max_salary &gt; 2500 
    THEN raise_application_error
    (-20202, 'Employee cant be over 5000');
  END IF;
  END; 
  </code></pre>
  
  <p>I'm trying to copy the format I see here in my book. but it gives a pop-up that asks to define :NEW  .. any tips appreciate</p>
  
  <p><img src="https://i.stack.imgur.com/shhJJ.png" alt="enter image description here"></p>