Hi , Facinng some problem with the delimiter with sql loaders.
I've a row like below in CSV.

"Value1","val"ue2","value3","value4"

I'm using
FIELDS TERMINATED BY ',' optionally enclosed by '"'

But the above syntax is not working. Can some on help on this pls.

>But the above syntax is not working.

my car is not working.
please tell me how to make my car go.

I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

If you know SQL Loader systax you could have understood what I'm asking for MR.Car

for it to work, the data must be like the following

"Value1","val""ue2","value3","value4" (double quotes in a string),
however if I was building the export I would use a pipe to separate the fields

Value1|val"ue2|value3|value4

FIELDS TERMINATED BY '|' optionally enclosed by '"'

That character is almost never used in data.

"Not working" is not a valid SQL*Loader error message....