SQLize Online / PHPize Online  /  SQLtest Online

CREATE OR REPLACE TRIGGER display_salary_changes BEFORE DELETE OR INSERT OR UPDATE ON customers FOR EACH ROW WHEN (NEW.ID > 0) -- Assuming ID is the primary key DECLARE sal_diff NUMBER; BEGIN IF UPDATING THEN -- Calculate salary difference for UPDATE operation sal_diff := :NEW.SALARY - :OLD.SALARY; ELSIF INSERTING THEN -- Calculate salary difference for INSERT operation sal_diff := :NEW.SALARY; ELSIF DELETING THEN -- Calculate salary difference for DELETE operation sal_diff := :OLD.SALARY; END IF; -- Display the salary difference (you can customize this part) DBMS_OUTPUT.PUT_LINE('Salary Difference: ' || sal_diff); END; /