Re: SQL*Loader question
From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/05/18
Message-ID: <si9h5a7nius141_at_corp.supernews.com>#1/1
Date: 2000/05/18
Message-ID: <si9h5a7nius141_at_corp.supernews.com>#1/1
"Michel Cadot" <micadot_at_netcourrier.com> wrote in message
news:8g0o0p$bv9$1_at_news2.isdnet.net...
> In the control file, you have to use the NULLIF clause
> for example:
>
> load data
> infile *
> replace
> into table tab
> (col position(01:04) char nullif col='NULL')
I also seem to remember a "nullif blanks" too, something like:
(col position(01:04) char nullif blanks)
-Matt Received on Thu May 18 2000 - 00:00:00 CEST