On Dec 6, 2009, at 1:49 PM, Tom Jackson wrote:
The "requirement" is the ability to handle both the empty string and
NULL.
Personally I like the Oracle behavior.
I mean, hell, there's even a daily WTF post about it:
http://forums.thedailywtf.com/forums/p/1225/26879.aspx
(in which many respondents prove they don't understand the SQL concept
of NULL, but that doesn't matter)
In SQL the empty string is the empty string. In Oracle, it's
equivalent to NULL. Not at all the same in SQL, but the same in Oracle.
Just go away until you 1) understand the SQL standard and 2) Oracle.
----
Don Baccus
http://donb.photo.net
http://birdnotes.net
http://openacs.org
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to
<lists...@listserv.aol.com> with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
