- //触发器名UserToTemp
- create or replace trigger UserToTemp after insert or update or delete
- on user_info for each row//对表user_info操作时触发以下事件
- declare//声明变量
- integrity_error exception;
- errno integer;
- errmsg char(200);
- dummy integer;
- found boolean;
- sexy varchar2(20);
- begin
- if inserting then
- select sex into sexy from user_info_test;//取出user_info_test表中的sex字段的值赋值给变量sexy
- insert into User_info_temp(ID,UserName,PassWord,Createdate,Status) values(:NEW.ID,:NEW.UserName,sexy,:NEW.createdate,:NEW.status);//:NEW.UserName的值为表user_info新增加的数据
- elsif updating then
- update User_info_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_temp where id=:OLD.id;
- end if;
- exception
- when integrity_error then
- raise_application_error(errno, errmsg);
- end;
原出处:http://www.iteye.com/topic/882897
写的非常简单非常好呀