select a.* from a left join b on a.caller = decode( regexp_instr(a.caller,'^1[3458]\d{9}$'),1,b.adphone,b.adcode);
或者: [-code=sql] select a.* from a left join b on a.caller = decode( regexp_instr(a.caller,'^(010|02\d|0[3-9]\d{2})?\d{6,8}$'),1,b.adcode,b.adphone); [/code]
或者:
select a.* from a left join b on a.caller = decode( regexp_instr(a.caller,'^(010|02\d|0[3-9]\d{2})?\d{6,8}$'),1,b.adcode,b.adphone);
select a.*
from a
left join b on a.caller = decode( regexp_instr(a.caller,'^1[3458]\d{9}$'),1,b.adphone,b.adcode);
或者:
[-code=sql]
select a.*
from a
left join b on a.caller = decode( regexp_instr(a.caller,'^(010|02\d|0[3-9]\d{2})?\d{6,8}$'),1,b.adcode,b.adphone);
[/code]
select a.*
from a
left join b on a.caller = decode( regexp_instr(a.caller,'^(010|02\d|0[3-9]\d{2})?\d{6,8}$'),1,b.adcode,b.adphone);