Re: Oracle NULL vs '' revisited

From: Thomas Kellerer <FJIFALSDGVAF_at_spammotel.com>
Date: Sat, 18 Aug 2007 15:40:47 +0200
Message-ID: <5iob6vF3rbmofU1@mid.individual.net>

William Robertson wrote on 18.08.2007 11:19:
> There was a long-running debate about this over on OTN forums last
> year, and I tried to get the poster there to explain why he wasn't
> concerned about "known no-value" DATEs when "known no-value" strings
> seemed to drive him crazy, and never got a proper answer there either.

I have never understood that distinction as well. Actually everybody (not only the poster on OTN and here) seems to be screaming about not having a known no-value vor strings but no one ever complained about dates or numbers (and no, I don't think zero is an approriate subsitution for '' in this example).

I remember that discussion on OTN and I too wanted to have an answer to that question ;)

Thomas Received on Sat Aug 18 2007 - 08:40:47 CDT