Create Trigger ins_EmailSend
before insert on Email_Sender
FOR EACH ROW
Begin
Insert Into Email_Receive
(EmailId,Receiever,Sender,Title,New,Content,Date,Memo)
values(:new.EmailId,:new:Receiever,:new.Sender,:new.Title,'0',
:new.Content,:new.Date,:newMemo);
End Insert_checking;
before insert on Email_Sender
FOR EACH ROW
Begin
Insert Into Email_Receive
(EmailId,Receiever,Sender,Title,New,Content,Date,Memo)
values(:new.EmailId,:new:Receiever,:new.Sender,:new.Title,'0',
:new.Content,:new.Date,:newMemo);
End Insert_checking;
要改成:old.colname.
既然你想取插入值,触发前与触发后执行插入动作都一样嘛!
但是oracle中带插入操作的触发器,不管是before insert 或after insert
而得到的:old均为空值,所以必须before insert,而且只能取:new.colname。
另外,如果插入操作失败,触发器也不会把错误值插入表Email_Receive中。
才会用到.old。