update_trigger

PHOTO EMBED

Sat Jun 08 2024 02:12:25 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

CREATE OR REPLACE TRIGGER trg
--before insert ON t
before update of sal on t
 --after insert on t
FOR EACH ROW
BEGIN
    DBMS_OUTPUT.PUT_LINE('A new record is being inserted into the employee table:');
    DBMS_OUTPUT.PUT_LINE('Employee ID: ' || :New.empno);
    DBMS_OUTPUT.PUT_LINE('Employee Name: ' || :New.ename);
    --DBMS_OUTPUT.PUT_LINE('Hire Date: ' || TO_CHAR(:NEW.hiredate, 'YYYY-MM-DD'));
END;
/
content_copyCOPY