ORACLE正则替换中文

环境：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