select tel, regexp_replace(tel, '.*(1[[:digit:]]{10}).*','\1')
from HKH_DX_TEL_20170731
where regexp_like(tel, '.*(1[[:digit:]]{10}).*');
06-15
1048
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-09
2310
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
05-01
396
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)