oracle触发器

（增加的触发器）
create or replace trigger sms_trigger
after insert on sms_morecord
for each row
begin
if(:new.vc2svccode='10625558963') then
 insert into t_morecord(seq_id,vc2feetermid,vc2content,vc2recvtime,vc2linkid,vc2svccode,vc2msgid,numgatewayid,vc2productid,numcontentlen,vc2msgfmt,vc2svctype,numgatewaryid) values(:new.seq_id,:new.vc2feetermid,:new.vc2content,:new.vc2recvtime,:new.vc2linkid,:new.vc2svccode,:new.vc2msgid,:new.numgatewayid,:new.vc2productid,:new.numcontentlen,:new.vc2msgfmt,:new.vc2svctype,:new.numgatewaryid);
 end if;
 end;
（表的修改的触发器）
create or replace trigger dianxin after insert or update or delete
on appreciation for each row
begin
if inserting then
insert into telecom (telecomid,telecomname,telecomdesc) values
(:new.appreciationid,:new.appreciationname,:new.appreciationdesc);

 ELSIF DELETING THEN
    DELETE FROM telecom WHERE telecomid=:OLD.appreciationid;
  ELSE
     UPDATE telecom SET telecomname=:NEW.appreciationname,telecomdesc=:new.appreciationdesc WHERE telecomid=:OLD.appreciationid;
  END IF;
end ;

（删除触发器）
drop trigger dianxin;