oracle 提取手机号码
select dhoracle账号, regexp_replace(dh, '.*(1[[:digit:]]{10}).*','\1')from tablewhere regexp_like(dh, '.*(1[[:digit:]]{10}).*')
oracle 提取手机号码
select dhoracle账号, regexp_replace(dh, '.*(1[[:digit:]]{10}).*','\1')from tablewhere regexp_like(dh, '.*(1[[:digit:]]{10}).*')