Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> HELP: loading strings with embedded escaped "

HELP: loading strings with embedded escaped "

From: Furkan Khan <khanf_at_home.com>
Date: Fri, 21 May 1999 19:36:23 GMT
Message-ID: <3745B6A7.3B6207FA@home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US