Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL - Select and filtering whereby a date is not null.
Kal, your problem might just be bad data. I suggest you perform a dump
function (See SQL manual) on the rel_end_date column for those rows
that you believe are null and should not be showing up. Depending on
how the columns were populated it is possible that a non-printable
value such as a binary zero, newline, carriage return, etc ... was
inserted into the column. Pro* language programs and OCI can easily do
this. If you find garbage in the columns then you can update them to
be proper NULL values. You would also want to search for the offending
program and fix it.
HTH -- Mark D Powell -- Received on Wed Mar 23 2005 - 08:15:40 CST