Statement Level Trigger query

CREATE OR REPLACE TRIGGER tr1

AFTER UPDATE ON emp

BEGIN

    DBMS_OUTPUT.PUT_LINE('Tomorrow Holiday');

END;

/

update emp set sal=sal+100 where deptno=80;

Output: 

Tomorrow Holiday

0 rows updated

drop trigger tr1;

No comments:

Post a Comment