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

Home -> Community -> Mailing Lists -> Oracle-L -> escaping single quote in sqlldr not working

escaping single quote in sqlldr not working

From: Peter J. Schoenster <webmaster_at_rede.com>
Date: Sun, 6 Aug 2000 16:47:46 -0600
Message-Id: <10581.113931@fatcity.com>


Hello,

absolute newbie here from a mysql background.

os: SunOS dev 5.8 Generic i86pc i386 i86pc oracle: 8.1.5

Seems best way to load data is with sqlldr and it works well enough but escaping a quote doesn't work, e.g.

'data\'s here '

is sent to the bad file.

I read:

http://oradoc.photo.net/ora81/DOC/server.815/a67792/ch05.htm#1462

> In DDL syntax, you can place a double quotation mark inside a
> string delimited by double quotation marks by preceding it with
> the escape character, "\" (if the escape is allowed on your
> operating system). The same rule applies when single quotation
> marks are required in a string delimited by single quotation
> marks.

I've always used the backslash for such things, certainly it's supported on the O/S.

Anyone with clues?

Thanks,

Peter



Exercise Your Brain, Read a Book
-- O Crazy Gringo, Ipanema, Brazil Received on Sun Aug 06 2000 - 17:47:46 CDT

Original text of this message

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