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

Home -> Community -> Usenet -> comp.databases.theory -> Re: 3vl 2vl and NULL

Re: 3vl 2vl and NULL

From: <jason.glumidge_at_gmail.com>
Date: 11 Dec 2005 16:16:14 -0800
Message-ID: <1134346574.162087.103130@g49g2000cwa.googlegroups.com>


Hugo Kornelis wrote:
> On Fri, 9 Dec 2005 23:34:03 +0100, Jon Heggland wrote:
> Hi Jon,
>
> And yet, that is all there is to it. A NULL in a database is exactly
> like an empty cell in a spreadsheet - there's room where you'd expect a
> value, but when you look there is no value.

Hi Hugo, I wonder if that is a completely accurate comparison? For example if I say that spreadsheet cell A1 is empty and A2 = A1 + 7, then A2 resolves to 7. This seems much more analagous to a A1 representing an empty string (like this pick that i keep hearing about on here). In a database a Null + anything would still be a Null - there seems a difference between non-existent and empty, RDBMS using the former, spreadsheets and pickies using the latter? Received on Sun Dec 11 2005 - 18:16:14 CST

Original text of this message

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