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