Re: SQL*Loader problem: Not loading Spaces into NULL column through direct load

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 17 Jan 2000 19:35:18 +0800
Message-ID: <3882FE76.1400@yahoo.com>

fatehahmad_at_hotmail.com wrote:
>
> Hi,
>
> I am using Oracle 8i. I am trying to load some data into a table by
> using SQL*Loader direct load option. One of the columns in that table is
> NULL. When loader encounters a row which try to insert spaces into the
> NULL column, it rejects that row. I couldn't find out a solution that
> stops this behaviour.
>
> Thanks
>
> Fateh Ahmad
> fatehahmad_at_yahoo.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Look at NULLIF col=BLANKS

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Jan 17 2000 - 05:35:18 CST