ORACLE如何找出某一列中含有中文的记录

Oracle 9i引入的一个字符函数
功能:返回字符对应的ASCII码,对于非ASCII码转化为Unicode并前置符号'/'

 

下面做个例子来看看

SQL> create table test(tt varchar2(10));

Table created.

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

1 row created.

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

1 row created.

SQL> insert into test values('@#$%');

1 row created.

SQL> insert into test values('po/efe');

1 row created.

SQL> commit;
SQL> select tt,asciistr(tt) from test;

TT         ASCIISTR(TT)
---------- --------------------------------------------------
haha       haha
哈哈       /FFFD/FFFD/FFFD/FFFD
@#$%       @#$%
po/efe     po/005Cefe

SQL> select * from t