Re: SQLLDR and NULLs

From: Richard Kuhler <noone_at_nowhere.com>
Date: Thu, 25 Apr 2002 19:41:23 GMT
Message-ID: <DZYx8.56977$VQ2.34003215@twister.socal.rr.com>

Are you sure the rows are being loaded?
What is the column actually filled with then?
What version of Oracle?
What OS version?
How about the whole control file?
How about a sample of the data file?

Richard

Jake wrote:
>
> Hello:
>
> I have loaded data into a table and one of the table columns is null
> but when I run a SQL query against the the table I get zero rows
> returned.
>
> ex. table Example has column D filled with nulls. When I run this
> query
>
> select count(*) from Example where D is null; I get zero rows!
>
> I even had this in my control file:
>
> (1) D char nullif D=blanks, same results
> (2) D char "decode(:D,null,null,:D), same resluts!
>
> Can anyone help me.
>
> Thanks in advance.
> Jake
Received on Thu Apr 25 2002 - 14:41:23 CDT