Re: sqlldr terminated by ',' with a ',' in one of my fields!

From: FC <flavio_at_tin.it>
Date: Thu, 12 Jun 2003 08:30:16 GMT
Message-ID: <sSWFa.78590$pR3.1642574@news1.tin.it>

If working with Oracle 8.1.7 or above, just replace the word FILLER with BOUNDFILLER in the control file fragment below. A standard filler field cannot be used inside expressions, whereas BOUNDFILLER can.

Bye,
Flavio

"JohnL" <jmfl54_at_hotmail.com> wrote in message news:3e707d7f.0306111359.769c0caa_at_posting.google.com...
> ...
> LOAD DATA
> INFILE date.csv
> REPLACE
> INTO TABLE date_test
> FIELDS TERMINATED BY ','
> (
> a FILLER ,
> b FILLER ,
> DATE_TESTER "to_date(:a ||' ' ||:b,'DD-MM-YYYY HH24:MI:SS')",
> scrap
> )
>
Received on Thu Jun 12 2003 - 03:30:16 CDT