C:>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 3月 25 21:08:19 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect / as sysdba
已连接。
SQL> create table t(id int , name varchar2(10));
表已创建。
SQL> insert into t values(1 , '');
已创建 1 行。
SQL> commit;
提交完成。
SQL> select * from t where name='';
未选定行
SQL> select * from t where name is null;
ID NAME
---------- ----------
1
SQL> insert into t values(2 , null);
已创建 1 行。
SQL> select * from t where name is null;
ID NAME
---------- ----------
1
2
SQL> select nvl(length(name),0),nvl(vsize(name),0) ,dump(name) from t;
NVL(LENGTH(NAME),0) NVL(VSIZE(NAME),0) DUMP(NAME)
------------------- ------------------ ----------
0 0 NULL
0 0 NULL
SQL>
转自-warehouse点击打开链接