Re: Differentiate Between Zero-Length String and NULLColumn Values

Just a datapoint:

SQL*Plus: Release 10.1.0.3.0 - Production on Tue Jan 30 15:15:49 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from dual where '' IS NULL;

D
-
X

SQL> select * from dual where '' = NULL;

no rows selected


-j