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求得是字节长度。