【oracle】监控表记录操作

环境：oracle 11g
通过触发器监控表，删除或更新记录

监控表

触发器

 create or replace trigger dept_updhis
    before update or delete on dept
    for each row
  begin
    if update then
      insert into dept_his
      values
        (:old.id, :old.name, :old.fzr, sysdate, 'update');
    else
      insert into dept_his
      values
        (:old.id, :old.name, :old.fzr, sysdate, 'delete');
    end if;
  end;

操作记录表