Sqlldr make double quote

From: Andrea <netsecurity@xxxxxxxxxx>
Date: Tue, 27 May 2008 05:38:20 -0700 (PDT)

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
.

Follow-Ups:
- Re: Sqlldr make double quote
  - From: fitzjarrell@xxxxxxx

Prev by Date: Re: instant client RH EL 4.4 sqlplus
Next by Date: Re: SQL Server for Oracle DBAs
Previous by thread: instant client RH EL 4.4 sqlplus
Next by thread: Re: Sqlldr make double quote
Index(es):
- Date
- Thread

Relevant Pages

Re: Sqlldr make double quote
... i'm trying to import csv data with sql loader, ... delimited by ";" and there isn't any double quote in csv. ... You've posted your control file, now post the contents of 'users.csv'. ...
(comp.databases.oracle.server)
Re: Sqlldr make double quote
... i'm trying to import csv data with sql loader, ... delimited by ";" and there isn't any double quote in csv. ... You've posted your control file, now post the contents of 'users.csv'. ...
(comp.databases.oracle.server)