Re: Basic Sqlldr question

What Jonathan said:

>From the SQLLDR reference:

"A string within double quotation marks cannot be embedded inside another string delimited by double quotation marks."

A test on 10.2 verified that at least under some circumstances, a string delimited by double
quotes and embedded within another double quote delimited string could be loaded, but
the quotes were removed.

In this case the double quotes appeared in succession at the end of the string: eg. data"","

You might like to look at the SQL*Loader Control File reference in the Utilities manual.

HTH Jared

On 12/9/05, rjamya <rjamya_at_gmail.com> wrote:
>
> I am loading a flatfile fields enclosed by double-quotes and delimited by
> comma. We found that some column values can also contain double-quotes. How
> do I _escape_ the double-quotes in the column values?
>
> TIA
> Raj
> ----------------------------------------------
> This space is available for rent.
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l