送分问题(第一次在ORCLE中写触发器),如何解决语法错误!
我想把表Email_Sender 的最后一条记录插入表Email_Receive中,语句如下,但是总是报错,麻烦各位高手指点迷津。:)
Create Trigger ins_EmailSend
after insert on Email_Sender
FOR EACH ROW
Begin
Insert Into Email_Receive (EmailId,Receiever,Sender,Title,New,Content,Date,Memo)
Select EmailId,Receiever,Sender,Title,'0',Content,Date,Memo
From inserted
End Insert_checking