Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Foreign key in Oracle Sql

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@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 - 16:41:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US