Re: Foreign key in Oracle Sql
From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Thu, 20 Jan 2005 14:41:12 -0800
Message-ID: <5uqvu01bh6e11n96jt7havhl4tfuubqrn3_at_4ax.com>
Date: Thu, 20 Jan 2005 14:41:12 -0800
Message-ID: <5uqvu01bh6e11n96jt7havhl4tfuubqrn3_at_4ax.com>
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 Received on Thu Jan 20 2005 - 23:41:12 CET