Sqlldr make double quote

From: Andrea <netsecurity_at_tiscali.it>
Date: Tue, 27 May 2008 05:38:20 -0700 (PDT)
Message-ID: <3457e233-0465-45b6-b25b-4d8a731c77ac@i76g2000hsf.googlegroups.com>

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.
Andrew Received on Tue May 27 2008 - 07:38:20 CDT

Original text of this message