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 versus empty string

Re: NULL versus empty string

From: <ctcgag_at_hotmail.com>
Date: 29 Sep 2002 01:38:23 GMT
Message-ID: <20020928213823.642$oC@newsreader.com>


"David Wall" <d.wall_at_computer.org> wrote:
>
> <quote>
>
> Do not use null to represent a value of zero, because they are not
> equivalent. (Oracle currently treats a character value with a length of
> zero as null. However, this may not continue to be true in future
> releases, and Oracle recommends that you do not treat empty strings the
> same as nulls.)

Yes, isn't that clever. Does that mean they recommend that you do not use their products?

> Any arithmetic expression containing a null always
> evaluates to null. For example, null added to 10 is null. In fact, all
> operators (except concatenation) return null when given a null operand."

Bull. The 'or' and 'and' operators can return true and false, respectively, if given a null operand assuming the other operand is true or false, respectively.

> </quote>

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
                    Usenet Newsgroup Service
Received on Sat Sep 28 2002 - 20:38:23 CDT

Original text of this message

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