Re: Sqlldr make double quote
Date: Tue, 27 May 2008 06:55:37 -0700 (PDT)
On May 27, 7:38 am, Andrea <netsecur..._at_tiscali.it> wrote:
> Hi guys,
> i'm trying to import csv data with sql loader, the fields are
> delimited by ";" and there isn't any double quote in csv.
> When i import it adds in all data of first and last column double
> quotes "
> the control file is follows:
> load data
> infile 'users.csv'
> into table TAB_USERS
> fields terminated by ";"
> (COL1, COL2, ....)
> after the import the results is:
> COL1 COL2 .. COL_LAST
> "text ok text"
> i don't understand why this behavior.
> thanks for any info.
You've posted your control file, now post the contents of 'users.csv'.
David Fitzjarrell Received on Tue May 27 2008 - 08:55:37 CDT