title: Trigger to insert data row into new table when old table is updated
body: <p>Want to insert only the updated row into the log table, but got error for the following trigger block : </p>
  
  <pre><code>CREATE OR REPLACE TRIGGER system_notification_audit
    AFTER INSERT OR UPDATE on ncr_system_notification
    FOR EACH ROW
  BEGIN
    insert into ncr_system_notification_log
    values
      (:NEW.ID,
       :NEW.NAME,
       :NEW.Description,
       :NEW.PREFERENCE,
       :NEW.FREQUENCY,
       :NEW.IS_HIGH,
       :NEW.IS_REQUIRED,
       :NEW.UPDATED_BY,
       :NEW.UPDATED_DATE) 
     where :OLD.IS_REQUIRED &lt;&gt; :NEW.IS_REQUIRED;
  END;
  </code></pre>