oracle 识别中文,全角

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

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