oracle提取手机号码

oracle 提取手机号码

select dh, regexp_replace(dh, '.*(1[[:digit:]]{10}).*','')
from table
where regexp_like(dh, '.*(1[[:digit:]]{10}).*')