Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NULL value EQUALS to EMPTY string?!

Re: NULL value EQUALS to EMPTY string?!

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Mon, 7 Feb 2000 14:58:35 +0000
Message-ID: <2MPfxcAb2tn4Ew2k@ahardy.demon.co.uk>


In article <87mh1c$gkr$1_at_nnrp1.deja.com>, Klim Samgin <klimsamgin_at_yahoo.com> writes
>Hi!
>
>It's notorious that table cells may have the special
>value null (or unknown).
>This value is different from the number 0,
>and it is also different from the empty string ''.
>
>But...

[snip]
>So, NULL is equal to '' for strings
>and is not equal to '' for numbers!
>
>Have you any comments?

The literal '' is the NULL string. Hence, all that happened above was the standard use of nulls.

Andy
--
Andy Hardy. PGP key available on request


Received on Mon Feb 07 2000 - 08:58:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US