环境: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;