Re: Foreign key in Oracle Sql

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 20 Jan 2005 15:23:57 -0800
Message-ID: <41f03d81$1_2@127.0.0.1>

Gene Wirchenko wrote:

> On Wed, 19 Jan 2005 14:24:30 -0800, DA Morgan
> <damorgan_at_x.washington.edu> wrote:
>
> [snip]
>
>

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

>
>
> With Oracle, all bets are off if any of your strings can be
> empty. If any can be, you get a NULL, like it or not.
>
> Sincerely,
>
> Gene Wirchenko

Well first of all everyone that writes code in any environment and isn't a fraud or a poser learns the strengths and weakenesses of that environment. So only a total moron would write an app in Oracle with empty strings: I certainly haven't in a decade. Because anyone that did would be providing prima-facia evidence that they couldn't or didn't read the docs.

That said SELECT NVL(col_name, <value>) or NVL2(col_name, <value>, <value>) solve any problem imaginable. In my opinion ... anyone that has a problem with this probably has a clip on tie and can't tie their own shoe laces.

-- 
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 Thu Jan 20 2005 - 17:23:57 CST