呜呼呼043267175399 价格问题
哈哈哈15888888888这个号码是我随便写的,如果有人的电话号码真是这个,那就是纯属巧合
regexp_replace(SERVICECONTENT, '.*(1[[:digit:]]{10}).*','\1') 结果是15888888888
regexp_like(SERVICECONTENT, '.*(1[[:digit:]]{10}).*')
UPDATE T_EXPERTSERVICERECODE SET SERVICECONTENT =
REPLACE(SERVICECONTENT,
regexp_replace(SERVICECONTENT, '.*(1[[:digit:]]{10}).*','\1'),
SUBSTR(regexp_replace(SERVICECONTENT, '.*(1[[:digit:]]{10}).*','\1'),1,3)||'****'|| SUBSTR(regexp_replace(SERVICECONTENT, '.*(1[[:digit:]]{10}).*','\1'),8,4)
)
WHERE regexp_like(SERVICECONTENT, '.*(1[[:digit:]]{10}).*') AND ROWNUM < 5000