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

Home -> Community -> Usenet -> c.d.o.tools -> Sqlldr imports newlines

Sqlldr imports newlines

From: <mchrist72_at_my-deja.com>
Date: Sun, 10 Sep 2000 16:01:01 GMT
Message-ID: <8pgb7l$loa$1@nnrp1.deja.com>

Hi,

sqlldr adds the <newline> (or <cr>, or \n) to my records. The (text) data file looks like:

aaaa,bbbb,cccc<cr>

after the import, the data in the table looks like:

aaaa,bbbb,cccc<cr>

how do I get rid of the <cr>? obviously, I do not want it to be imported.

Thanks in advance,
Mario

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Sep 10 2000 - 11:01:01 CDT

Original text of this message

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