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