一个简单的触发器示例

-- 创建备份表      
create table emp_his as (select * from emp where 1=2);

创建触发器内容

<pre name="code" class="sql">-- 创建触发器 
create or replace trigger tr_emp_del
-- 对scott.emp表在delete操作之前
  before delete on scott.emp
-- 对每一行进行触发动作
  for each row

-- 触发的具体动作
DECLARE
BEGIN

  INSERT INTO emp_his
    (deptno, empno, ename, job, mgr, sal, comm, hiredate)
  VALUES
    (:old.deptno,
     :old.empno,
     :old.ename,
     :old.job,
     :old.mgr,
     :old.sal,
     :old.comm,
     :old.hiredate);
END;
/

测试

delete from emp where empno = 7369;
select * from emp_his;

PS：创建触发器那一段代码，在sql 窗口无法正常执行，会报错，必须放到命令窗口去方可