Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NULL value EQUALS to EMPTY string?!
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
![]() |
![]() |