Re: Warning about null and open question to Oracle

From: Simon Thompson <scthomp_at_ibm.net>
Date: 1995/06/18
Message-ID: <3s121o$kl1_at_news-s01.ny.us.ibm.net>#1/1


:>To solve your problem, either use NVL or use IS NULL. For example:
:>
:>if ( nvl( a, 0 ) = nvl( b, 0 ) ) then
:> .....
:>end if;

If null compared with null is unlnown, does that mean the result is NULL? I.e., would nvl(a=b, 0) return 0 is a and b are null? (Not sure if this would be useful). Received on Sun Jun 18 1995 - 00:00:00 CEST

Original text of this message