Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> HELP: loading strings with embedded escaped "
Folks, I am trying to use sql*loader to load
string that have embedded escaped
double quotes (\").
I have the delimiter defined as:
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
data looks like:
1111,"here it is \"new\" ...",9000,............
For some reason sql loader doesnt recognize escape strings.
Any help appreciated.
You can mail me directly also.
Thanks in advance.
Regards.
Furkan Received on Fri May 21 1999 - 14:36:23 CDT
![]() |
![]() |