CREATE OR REPLACE TRIGGER salary_trigger BEFORE UPDATE OF sal ON e FOR EACH ROW BEGIN IF :OLD.sal <> :NEW.sal THEN DBMS_OUTPUT.PUT_LINE('Salary changed for employee ' || :OLD.employee_id || ': ' || :OLD.sal || ' -> ' || :NEW.sal); END IF; END; /
CREATE OR REPLACE TRIGGER salary_trigger BEFORE UPDATE OF sal ON e FOR EACH ROW BEGIN IF :OLD.sal <> :NEW.sal THEN DBMS_OUTPUT.PUT_LINE('Salary changed for employee ' || :OLD.employee_id || ': ' || :OLD.sal || ' -> ' || :NEW.sal); END IF; END; /