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: Select problem

Re: Select problem

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 28 Feb 2005 14:33:53 -0800
Message-ID: <1109629866.798897@yasure>


blue wrote:

> We have a customer using our software with an Oracle 9.2.0.4 database.
> Select statements do not return any records where at least one column has a
> NULL value. We're talking about basic selects to such as SELECT * FROM
> batch_schedule WHERE status = 'A'. If I populate all the columns in that
> record with at least empty string, then the record is returned. The
> customer also informed me that he's had this trouble with other software
> running against his Oracle DB as well, but didn't know why.
>
> Running the same code in our test environment here with an Oracle 9.2.0.1
> database, all works as planned.
>
> Is there some kind of Oracle setting for this?
>
> Thanks for your help.
> Frank

You are not working with Oracle if you can enter an empty string and get a behaviour different from NULL. Please post the appropriate DDL and DML so that we can see what it is you are doing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Feb 28 2005 - 16:33:53 CST

Original text of this message

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