环境：11.2.0.4.0，字符集UTF8
with test1 as (
select '离学校放假倒计时第20天' a from dual
union all
select '离学校放假倒计时第19天' a from dual
union all
select '离学校放假倒计时第18天' a from dual
union all
select '离学校放假倒计时第17天' a from dual
union all
select '离学校放假倒计时第16天' a from dual
)
select regexp_replace(a,'[' || unistr('\0391') || '-' || unistr('\9fa5') || ']','') from test1
REGEXP_REPLACE(A,'['||UNISTR('
--------------------------------------------------------------------------------
20
19
18
17
16
