Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLoader & carriage returns
You can tell SQLLoader to replace the return character with something else. How are you loading, fixed width or are you loading by delim.?
Alun Harriss wrote:
> How do you get SQLLoader to import data that has Carriage Returns embedded
> in its text fields? - SQLLoader interprets a carriage return as the start of
> a new row of data. Can you use some sort of escape character?
>
> Thanks,
> A Harris
>
> --
> Posted from [213.210.4.190]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Mar 30 2001 - 10:32:23 CST
![]() |
![]() |