oracle中表insert or update or delete触发器

在一个表（User_Info_2017 ）上放置一个触发器；

当对它进行insert，update，delete的操作时，触发器（UserToTemp ）启动，

把相应的变动数据根据需要放到另外一个表（User_Info_2017_temp ）中；

触发器代码如下：

create or replace trigger UserToTemp after insert or update or deleteon User_Info_2017 for each rowdeclare    integrity_error exception;    errno            integer;    errmsg           char(200);    dummy            integer;    found            boolean;beginif 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;