SELECT *
FROM table a
WHERE LENGTH (id) != LENGTHB (id);
Oracle 中length()与lengthb()区别
SQL> select length('姗姗') from dual;
LENGTH('姗姗')
--------------
2
SQL> select lengthb('姗姗') from dual;
LENGTHB('姗姗')
---------------
4
区别:length求得是字符长度,lengthb求得是字节长度。
转载:http://oracle.chinaitlab.com/exploiture/802189.html