Hi guys,
i'm trying to im****t csv data with sql loader, the fields are
delimited by ";" and there isn't any double quote in csv.
When i im****t 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 im****t the results is:
COL1 COL2 .. COL_LAST
"text ok text"
i don't understand why this behavior.
thanks for any info.
Andrew
