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 -> Include Null values in SELECT output

Include Null values in SELECT output

From: Randy Harris <randy_at_SpamFree.com>
Date: Sun, 16 Nov 2003 01:56:37 GMT
Message-ID: <pPAtb.10448$P%1.9207659@newssvr28.news.prodigy.com>


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. Received on Sat Nov 15 2003 - 19:56:37 CST

Original text of this message

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