Trigger Ex-2

--assignment 3 question 7 aniket RD assignement
CREATE OR REPLACE TRIGGER trg_ere
after UPDATE ON employee
FOR EACH ROW
BEGIN
    IF updating THEN
        INSERT INTO empraise (empraiseid,employeeid,raise_date,raise_amount )VALUES('er'||sw.NEXTVAL,:old.employeeid,SYSDATE,:NEW.salary  - :old.salary);
    END IF;
END trg_ere;
/