Re: Oracle NULL vs '' revisited

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 28 Aug 2007 20:23:05 +0200
Message-ID: <fb1p69$59l$1@news2.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

William Robertson wrote:
> On Aug 26, 2:17 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:

>> NULL <> NULL, but '' = '', if that would help.
>> The length of NULL is NULL again.

>
> If we had a '' in Oracle then its length would be 0, but we don't,
> which is the subject of this thread. I was hoping someone could
> provide an example of non-null '' being a useful value.
>

Well, what's there to say? Apart from two obvious things:

• - it's not according to the ANSI SQL standard (yeah, yeah - we know)
• - learn to live with it (or ditch Oracle).

<ot>
I was quite surprised to find out recently, there's a tribe that actually uses the NULL in daily speak; sort of maybe yes, maybe no - it's not true, but not false, either. Hence the name Amazon logic.
</ot>
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG1GgJLw8L4IAs830RAmIvAJ92/KQB0t2PwGi8ifmV3RPZ0yynQwCfdenV 4+pYErmOFh8++DfTSxxv/ww=
=5whA
-----END PGP SIGNATURE----- Received on Tue Aug 28 2007 - 13:23:05 CDT