17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> select * from test where username is null;
USERNAME USERNUM
-------------------- ---------------------------------------
234
SQL> select * from test where username ='';
USERNAME USERNUM
-------------------- ---------------------------------------
SQL> select * from test where username=' ';
USERNAME USERNUM
-------------------- ---------------------------------------
在oracle 中判断为空就用is null;