计算机3班 2018212513 张俊浩 实验10.docx

触发器 触发器示例1 create or replace trigger t_one after delete on scott.emp for each row begin insert into emp_info values(:old.empno,:old.ename,:old.job,:old.mgr,:old.hiredate,:old.sal,:old.comm,:old.deptno); dbms_output.put_line('delete sucessfully'); end t_one; SQL> delete from scott.emp