oracle 分辨中文,全角

oracle 识别中文,全角select count(*) from t where asciistr(member_id) like %\%这个SQL 识别中文,全

oracle 识别中文,全角
select count(*) from t where asciistr(member_id) like '%\%';  这个SQL 识别中文,全角..

select Count(*) FROM t_member WHERE translate(member_id, '\1234567890', '\') IS NOT null   识别是否是非数字