with chenxu as
(
select '老头子大帅哥!handsome!イケメン!' as a from dual
)
select a,regexp_replace(a,'[^' || unistr('\4E00') || '-' || unistr('\9FA5') || ']','')
from chenxu
;
Oracle中不支持/u4e00这种写法,所以只能通过unistr转换。
with chenxu as
(
select '老头子大帅哥!handsome!イケメン!' as a from dual
)
select a,regexp_replace(a,'[^' || unistr('\4E00') || '-' || unistr('\9FA5') || ']','')
from chenxu
;
Oracle中不支持/u4e00这种写法,所以只能通过unistr转换。