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;
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;
后边的info是不是需要加:new
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;
这个语法怎么用第一次见过