Can anyone explain the logic in this for me??
From: J.P. <jp_boileau_at_yahoo.com>
Date: 1 Mar 2002 12:19:04 -0800
Message-ID: <7e388bc3.0203011219.9e6e569_at_posting.google.com>
Date: 1 Mar 2002 12:19:04 -0800
Message-ID: <7e388bc3.0203011219.9e6e569_at_posting.google.com>
1* SELECT 'X' FROM DUAL WHERE '' = NULL SQL> / no rows selected
Elapsed: 00:00:00.00
SQL> SELECT 'X' FROM DUAL WHERE '' IS NULL
2 /
'
-
X
Now why is the empty string ( '' ) <> null but the same empty string IS NULL ?
JP Received on Fri Mar 01 2002 - 21:19:04 CET