Re: SQL*Loader question

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/05/18
Message-ID: <8g0o0p$bv9$1_at_news2.isdnet.net>#1/1


[Quoted] 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')

--
Have a nice day
Michel


Bernard Niset <bn_at_7ways.com> a écrit dans le message : 8g0k8v$1i9n$1_at_news4.isdnet.net...

> I can't remind how to specify that the litteral value NULL in the input file
> should be considered as a null value by the sqlloader.
> Cheers,
> -----------------------------------------
> Bernard Niset
> 7Ways development team
> http://www.tldnames.com
> -----------------------------------------
>
>
Received on Thu May 18 2000 - 00:00:00 CEST

Original text of this message