17,140
社区成员




with t1 as
(
select 1 id,'tel:13889233453' cont from dual union all
select 2 id,'x:010-38392231' from dual union all
select 3 id,'I have a wach' from dual union all
select 4 id,'ph:010-33884499' from dual union all
select 5 id,'your number is 021-3821234234?' from dual
)
select id,cont
from t1
where regexp_like(cont,'(\d{3}-)?\d{8}|(\d{4}-)(\d{7})')
or regexp_like(cont,'^1[3|4|5|8][0-9]\d{8}$')
id cont
----------------------------------------
1 1 tel:13889233453
2 2 x:010-38392231
3 4 ph:010-33884499
4 5 your number is 021-3821234234?