Re: Foreign key in Oracle Sql

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.

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