create or replace trigger trig_outfirstdetail_status
after update of splitcount on outfirstdetail
for each rowbeginif :new.splitcount =:new.count then
:new.statuscode:= 3;
else if :new.splitcount < :new.count then
:new.statuscode:=2;else if :new.splitcount = 0 then
:new.statuscode := 1;
end if;
end ;执行上面的触发器总是报错Compilation errors for TRIGGER OUTBOUND.TRIG_OUTFIRSTDETAIL_STATUSError: PLS-00103: Encountered the symbol ";" when expecting one of the following:
if
Line: 17
Text: end ;
鄙人实在是看不出来有什么错误了,请高人指点
after update of splitcount on outfirstdetail
for each rowbeginif :new.splitcount =:new.count then
:new.statuscode:= 3;
else if :new.splitcount < :new.count then
:new.statuscode:=2;else if :new.splitcount = 0 then
:new.statuscode := 1;
end if;
end ;执行上面的触发器总是报错Compilation errors for TRIGGER OUTBOUND.TRIG_OUTFIRSTDETAIL_STATUSError: PLS-00103: Encountered the symbol ";" when expecting one of the following:
if
Line: 17
Text: end ;
鄙人实在是看不出来有什么错误了,请高人指点
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货