Re: Weird Query

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 01 Aug 2005 11:23:23 -0500
Message-ID: <knise1tt0au2ffpss32ars064rsuevpsfl@4ax.com>

Andreas Mosmann <keineemails_at_gmx.de> wrote:

>Turkbear schrieb am 01.08.2005 in
><vlese1hl24777o6jalga0j7tvlrg787n8j_at_4ax.com>:
>
>I read all above, but only for being sure:
>
>There is no way to tell an oracle database that there is a known
>zero-value string? This information depraves to NULL?
>
>wondering
>
>Andreas

NULL means Unknowable, so NO, you cannot tell Oracle that some/all NULLS are anything but NULL. ( A Zero value string has a length of 0, so it cannot have a value ( what would be known about it other that its length?))

Why do you care..Oracle handles it just fine. When using it in a Where clause test for both blanks and Nulls with ( If trim( stringField) = '' or
stringField IS NULL)

Or use Oracle's NVL function to have Nulls return a specified value

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Received on Mon Aug 01 2005 - 11:23:23 CDT