正则处理特殊字符(Oracle)
with t as
(
select ‘a&**’ c1 from dual union all
select ‘bbbb’ c1 from dual union all
select ’ . d’ c1 from dual union all
select ‘1234’ c1 from dual union all
select ‘98sd8f’ c1 from dual union all
select ‘98/d8f’ c1 from dual union all
select ‘(sd)’ c1 from dual union all
select replace(‘123 321’,’ ‘,’’) c1 from dual
)
select regexp_replace(c1,’[[:punct:]]+’, ‘’)
from t
where regexp_like(c1,’[[:punct:]]+’);