Re: Foreign key in Oracle Sql

From: David Cressey <david.cressey_at_earthlink.net>
Date: Tue, 18 Jan 2005 18:28:35 GMT
Message-ID: <nzcHd.4487$Rs.1006@newsread3.news.atl.earthlink.net>

<ak_tiredofspam_at_yahoo.com> wrote in message news:1106063343.612382.242300_at_z14g2000cwz.googlegroups.com...
> >> I think NULL means a lack of a value .... I think a zero length
> string
> is a zero length string from twoentirely different things. BTW ... NULL
> in Oracle does not have single quotes around it.
> ..<<
>
> I think you aren't getting it

I think Oracle isn't getting it. The zero length string is not the absence of data, just as the number zero isn't the absence of a number. Oracle's support for NULLS is limited, and this is one place where they screwed up. They admit it in their own documentation.

There are other DBMS products that get this one right. Received on Tue Jan 18 2005 - 12:28:35 CST