读书人

小弟我写的触发器哪错了呢

发布时间: 2011-12-17 23:37:33 作者: rapoo

我写的触发器哪错了呢?
Create or Replace Trigger demo.TRIG_Demo
after Insert On Tab1 For Each Row
Begin
When (:new.info like '__________2% ' or info like '___________2% ')
Begin
Insert Into Tab_TMP (xm,tel,address)
values(:new.xm,:new.tel,:new.address);
end;
end;

Create or Replace Trigger demo.TRIG_Demo
after Insert On Tab1 For Each Row
Begin
if substr(:new.info,10,1)= '2 ' or substr(info,11,1)= '2 ' then
Insert Into Tab_TMP (xm,tel,address)
values(:new.xm,:new.tel,:new.address);

end if;
end;


[解决办法]
Create or Replace Trigger demo.TRIG_Demo
after Insert On Tab1 For Each Row
Begin
if substr(:new.info,10,1)= '2 ' or substr(:new.info,11,1)= '2 ' then
Insert Into Tab_TMP (xm,tel,address)
values(:new.xm,:new.tel,:new.address);

end if;
end;

读书人网 >oracle

热点推荐