Re: null values in oracle
From: Austin Moseley <austinmoseley_at_hotmail.com>
Date: Tue, 02 Feb 1999 14:42:26 -0600
Message-ID: <36B76332.18A72BE0_at_hotmail.com>
Date: Tue, 02 Feb 1999 14:42:26 -0600
Message-ID: <36B76332.18A72BE0_at_hotmail.com>
Yes, just add "AND variable_name IS NOT NULL" to your where clause. Or, alternatively, make the column a NOT NULL column.
-A
>
>
> > 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 - 21:42:26 CET