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

Home -> Community -> Usenet -> c.d.o.server -> NULLs

NULLs

From: Andrew Clark <lark047_at_hotmail.com>
Date: Tue, 20 Dec 2005 21:33:34 +0000
Message-ID: <Xns9732A979D7E33AddpaAdBb@66.150.105.47> 





Hello,



I have an application whose database was recently upgraded from 7 to 9i. In 
a bit of code, columns are compared that may both be null. In Oracle 7, 
will two columns compare equal if they are both NULL? In 9i it seems that 
they do not and I have to change it to NVL(column1) = NVL(column2).



Thanks,


Andrew
Received on Tue Dec 20 2005 - 15:33:34 CST












Original text of this message













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