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
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...Received on Thu May 18 2000 - 00:00:00 CEST
> 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
> -----------------------------------------
>
>