Oracle SQL,PL/SQL ,Realtime Scenarios, Interview Questions
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