Re: Foreign key in Oracle Sql
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 18 Jan 2005 15:07:46 -0800
Message-ID: <41ed96ba$1_1_at_127.0.0.1>
>
>
> 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.
Date: Tue, 18 Jan 2005 15:07:46 -0800
Message-ID: <41ed96ba$1_1_at_127.0.0.1>
David Cressey wrote:
> <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.
Given that those other products didn't exist when Oracle was created. And given that those that have worked with Oracle for almost 20 years have a large volume of working code they don't want broken. And given that it really doesn't matter ... what's your point other than whining?
That Oracle should gut its product and make it just another flavour of Microsoft vanilla?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond) ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =---Received on Wed Jan 19 2005 - 00:07:46 CET