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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Include Null values in SELECT output

Re: Include Null values in SELECT output

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Sun, 16 Nov 2003 14:33:35 +0100
Message-ID: <bp7ubf$ikn$1@svr7.m-online.net>

Randy Harris schrieb:
> Is there any sort of simple setting to cause Oracle 8.1.7 to include Null
> values in a <> Where clause?
>
> SELECT .... FROM ....
> WHERE Status <> 'Completed';
>
> In this particular case, Status is set to permit Null values and I would
> like the query to return ALL records that don't have "Completed" for the
> Status, including any that are Null.
>
> Note: I've updated the application to put a default Status in the field, but
> there are still many legacy records with no Status, and a number of other
> Fields with the same situation.
>
>

What about

SELECT ...
FROM ...
WHERE status <> 'Completed'
OR status IS NULL; Received on Sun Nov 16 2003 - 07:33:35 CST

Original text of this message

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