title: trigger fire when SAL col is updated with new salary hike. Also Trigger will update 20% of salary hike amount in X col in EMPL table
body: <p>Write a trigger which will fire when SAL column is updated with new salary hike. Also Trigger will update 20% of salary hike amount in  C_M column in “EMPL” table.</p>
  <pre><code>AFTER UPDATE OF SAL
  ON EMPLOYE
  FOR EACH ROW
  WHEN (new.sal &gt;old.sal)
  DECLARE
  SAL_DIFF employe.sal%type;
  BEGIN
  UPDATE EMPLOYE SET COMM=(SAL_DIFF*20)/100
  WHERE SAL_DIFF=:NEW.SAL-:OLD.SAL;
  EXCEPTION
  WHEN NO_DATA_FOUND
  THEN
  DBMS_OUTPUT.PUT_LINE('PL/SQL: ORA-00933: SQL command not properly ended');
  WHEN others THEN 
  DBMS_OUTPUT.PUT_LINE('PLS-00103: Encountered the symbol &quot;;&quot; when expecting one of the following:');
  END;
  </code></pre>