Re: Escape sequences in SQL*Loader

I ended up writing my own ProC-routine to do this job. I did not find any
way to do it in SQL*Loader.

Lars Jørgen Tvedt

Morten Myrvold wrote:
>
> Hi all,
> I'm using SQL*Loader to load our database tables from text files. Some of
> these columns contain text with CR's embedded. My question is: how do I
> specify a CR (carriage return) in my SQL*Loader data file??? As far as I can
> tell, each row in the text file corresponds to exactly one row in the
> database table (so inserting a "real" carriage return is not the solution).
> I've tried to use the commonly-used escape character '\' (backslash) and the
> hex-code for linefeed (0x0A). However, it doesn't seem that SQL*Loader
> treats my backslash as an escape character??? I also tried the C syntax '\n'
> with no luck...
> In SQL*Plus, I discovered that there's an ESCAPE option (which by the way is
> default OFF on my system).
> SET ESCAPE ON results in SQL*Plus seemingly ignoring all my backslashes in
> INSERTs (except of course when I double-backslash - a single backslash is
> produced). I'd like to think that there's a similar option for use with
> SQL*Loader that I have to enable for it to accept my newlines. Is this the
> casae? If so, how do I enable it? I'm not able to find any info on this
> subject...
>
> Regards,
> Morten Myrvold
> Sysdeco Profdoc AS, Kongsberg, NORWAY
 

-- 
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Lars Jørgen Tvedt, Dokumentasjonsprosjektet, Universitetet i Oslo
Postboks 1123 Blindern, N-0317 OSLO  
Telefon (+47) 22 85 49 84,    Fax (+47) 22 85 49 83