Re: Empty String equivalent to Nulls

From: Paul Quenneville <paulq_at_home.com>
Date: Wed, 24 Oct 2001 13:43:53 GMT
Message-ID: <tAzB7.96738$5h5.38608923@news3.rdc2.on.home.com>

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option
JServer Release 9.0.1.1.1 - Production

SQL> select 'x' from dual where '' is null 2 ;

'
-
x

SQL>
"David Klugmann" <dklugmann_at_lastminute.com> wrote in message news:45ac59b2.0110240211.742f2118_at_posting.google.com...
> Hi
>
> Does anyone know if in version 9i it is still the case that the empty
> string is considered a null, or has this now been corrected ?
>
> Thanks
Received on Wed Oct 24 2001 - 08:43:53 CDT