create table test(a varchar2(10));insert into test values('鳥');insert into test values('深刻');insert into test values('aaa');insert into test values('bbb');insert into test values('b鳥bb');SELECT * FROM TEST;

select a, asciistr(a) from test where asciistr(a) like '%/%'; -- 結果是有漢字的select a ,asciistr(a) from test where asciistr(a) not like '%/%'; -- 結果是不包含漢字的

select a, length(a) , lengthb(a) from TEST where length(a) != lengthb(a) ; --結果是有漢字的