Re: Empty String equivalent to Nulls

Hi David,

in Oracle 9i, empty strings '' are still equivalent to null, here is the test ive done in Oracle 9i :

SQL> select 1
  2 from dual
  3 where '' is null;

         1

         1

SQL> select 1
  2 from dual
  3 where null is null;

         1

         1

I assume you are the dba for lastminute.com, could you please remove my email address from the mailing list, I tried 3 times and it didn't worked... !
here is the email address : patrick_hamou_at_hotmail.com

thanks in advance !!

Patrick Hamou
Principal Consultant
Renaps Technology Canada inc.
www.renaps.com

dklugmann_at_lastminute.com (David Klugmann) 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 - 11:31:01 CDT