Re: null values in oracle
From: Ian C. Sellers <icslu_at_co.boulder.co.us>
Date: Tue, 02 Feb 1999 10:39:53 -0700
Message-ID: <36B73869.972E33C0_at_co.boulder.co.us>
Date: Tue, 02 Feb 1999 10:39:53 -0700
Message-ID: <36B73869.972E33C0_at_co.boulder.co.us>
Hi Filip,
Be sure to use NVL function or an equivalent in the join because a NULL value never equals anything else. e.g. ...where T1.OWNER_NAME = T2.OWNER_NAME will not ever be true if either side is null, and the query will return nothing. The Oracle docs on the NVL function explain this well.
Otherwise you may be describing a need for an outer join, also explained in the Oracle docs.
Good Luck,
-Ian
Filip Vantomme wrote:
> Is there anyway to avoid that records with null values in a
> join are not taken ???
>
> Thanks in advance
>
> Filip Vantomme
>
> Please also mail any replies.
Received on Tue Feb 02 1999 - 18:39:53 CET