Snail mail-oracle basics (3) -- triggers

Create a trigger. When a record is deleted from the employee table emp, write the deleted record to the employee table deletion log table.

-- Create a trigger to add the employee information to the log information table emp_his before deleting employee 7934 from the employee table. Create or replace trigger trig_empbefore delete on empfor each rowbegin insert into emp_his values (: old. empno,: old. ename,: old. job,: old. mgr,: old. hiredate,: old. sal,: old. comm,: old. deptno); end; delete emp where empno = 7934;