1.asciistr:匹配字段中是否有中文字段:
select asciistr('中文,zhongwen') from dual;
2.to_multi_byte、to_single_byte:匹配字段中的全角半角字符:
select to_multi_byte('test') from dual; select to_single_byte('test') from dual;