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_at_newsread3.news.atl.earthlink.net>
Date: Tue, 18 Jan 2005 18:28:35 GMT
Message-ID: <nzcHd.4487$Rs.1006_at_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.