Re: Foreign key in Oracle Sql

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 19 Jan 2005 14:24:30 -0800
Message-ID: <41eede13$1_1_at_127.0.0.1>


ak_tiredofspam_at_yahoo.com wrote:

>>>Given that those other products didn't exist when Oracle was

>
> created.
> .. <<
>
> you are not saying that IBM did not exist when Oracle was created, are
> you?

Not at all. But the code bases for DB2 did not in its various host environments did not.

>>>And given that it really doesn't matter

>
> ..<<
> for the developers who need to plug this leak, it very much does matter

NVL. Simple solution when it matters. But far better to design your database, no matter whether Oracle or Sybase, to not allow NULLs.

-- 
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 - 23:24:30 CET

Original text of this message