zhongjh168的博客通过本文主要向大家介绍了oracle,触发器等相关知识,希望本文的分享对您有所帮助
在一个表（User_Info_2017 ）上放置一个触发器；
当对它进行insert，update，delete的操作时，触发器（UserToTemp ）启动，
把相应的变动数据根据需要放到另外一个表（User_Info_2017_temp ）中；
触发器代码如下：
create or replace trigger UserToTemp after insert or update or delete
on User_Info_2017 for each row
declare
integrity_error exception;
errno integer;
errmsg char(200);
dummy integer;
found boolean;
begin
if inserting then
insert into User_Info_2017_temp(ID,UserName,PassWord,CreateDate,Status) values(:NEW.ID,:NEW.UserName,:NEW.PassWord,:new.CreateDate,:NEW.Status);
elsif updating then
update User_Info_2017_temp set ID=:NEW.ID,UserName=:NEW.UserName,PassWord=:NEW.PassWord,Status=:NEW.Status where id=:OLD.id;
elsif deleting then
delete from User_Info_2017_temp where id=:OLD.id;
end if;
exception
when integrity_error then
raise_application_error(errno, errmsg);
end;