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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLoader & carriage returns

Re: SQLLoader & carriage returns

From: David Busby <dbusby3_at_slb.com>
Date: Fri, 30 Mar 2001 10:32:23 -0600
Message-ID: <3AC4B517.5817A7E9@slb.com>

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

Original text of this message

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