Re: Foreign key in Oracle Sql
Date: Wed, 19 Jan 2005 15:48:50 GMT
Message-ID: <CjvHd.324$rp1.261_at_newsread3.news.atl.earthlink.net>
> 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?
My point is not whining. In fact, my general opinion of Oracle is a
favorable one.
But if they get something wrong, it deserves to be called wrong. Especially
in the context of this thread, where somebody is using Oracle behavior to
prove the point to somebody else.
Two points deserve mention:
The first is that there was at least one commercial Relational DBMS product that got this particular thing right 20 years ago.
The second is that Oracle warns its users that code that depends on the confusion between the empty string and NULL might be broken in a future release of Oracle! (emphasis mine). If you don't believe me, check out the Oracle documentation.
>
> That Oracle should gut its product and make it just another flavour of
> Microsoft vanilla?
Absolutely not! I never said that, and I don't intend to imply that!
Read some more of my posts before you conclude whether I'm just whining or not. Received on Wed Jan 19 2005 - 16:48:50 CET