salary_trigger

PHOTO EMBED

Sat Jun 08 2024 02:09:43 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

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;
/
content_copyCOPY