Sqlldr make double quote
Date: Tue, 27 May 2008 05:38:20 -0700 (PDT)
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:
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