SQL> create table test(id varchar2(60));

Table created

SQL> insert into test values('张abc');

1 row inserted

SQL> insert into test values('abc');

1 row inserted

SQL> insert into test values('张');

1 row inserted

SQL> commit;

SQL> select id from test where asciistr(id) like '%%';

ID
------------------------------------------------------------
张abc
张

SQL> select * from test where length(id)!=lengthb(id);

ID
------------------------------------------------------------
张abc
张

ITPub博客

判断字段中是否有汉字