一个简单的触发器示例

-- 创建备份表      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-- 触发的具体动作DECLAREBEGIN  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 窗口无法正常执行，会报错，必须放到命令窗口去方可