with ltz as (
select 'laotouzi真帅' as t from dual union all
select 'laotouzizhen shuai!' from dual union all
select '老头子zhenshuai' from dual union all
select '老tou子真帅' from dual union all
select '老头子真帅!!!a' from dual union all
select '老头子123真帅hehe!!!' from dual
)
select regexp_replace(regexp_replace(asciistr(t),'\\[[:alnum:]]{4}'),'[[:punct:]]') from ltz
1 个回复
老头子 - 专注是唯一的捷径 2016-12-21 回答
赞同来自: _缘君_