Re: Foreign key in Oracle Sql

On Tue, 18 Jan 2005 15:07:46 -0800, DA Morgan <damorgan_at_x.washington.edu> wrote:

>David Cressey wrote:
>> <ak_tiredofspam_at_yahoo.com> wrote in message
>> news:1106063343.612382.242300_at_z14g2000cwz.googlegroups.com...

[snip]

>> 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?

     I think you protest overmuch. Would it really take gutting Oracle to correct empty strings being equivalenced to NULL? Does that really equate to being like Microsoft?

Sincerely,

Gene Wirchenko Received on Wed Jan 19 2005 - 18:35:37 CET