Re: NULLs

Andrew Clark wrote:
> 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).

This is how it is supposed to be now. See http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/68ea8638b2d2e200/e38d8c83cb6f5572?lnk=st&q=comparing+nulls+group%3A*oracle*&rnum=2&hl=en#e38d8c83cb6f5572 among many other discussions, as well as http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7872367634114

jg

--
@home.com is bogus.
Yay!
http://www.smh.com.au/news/tv--radio/off-the-planet/2005/12/10/1134086846734.html