当前位置: 代码迷 >> Oracle开发 >> 小弟我写的触发器哪错了呢
  详细解决方案

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

热度:131   发布时间:2016-04-24 07:52:41.0
我写的触发器哪错了呢?
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;
  相关解决方案