Re: SQLoader and CR/LF

From: Noel <tbal_at_inchrosoft.com.pl>
Date: Thu, 16 Aug 2001 16:18:17 +0200
Message-ID: <3b7bd467_at_news.vogel.pl>


I'm affraid sqlldr first reads line then analizes that line. In that case there is no possibility to read data with CR/LF's correctly. I dig some oracle manuals to figure out if i'm correct.

/Noel

Użytkownik "Jacek Pichla" <jpichla_at_wp.pl> napisał w wiadomości news:9lfu6n$q0c$1_at_news.tpi.pl...
> Hi
>
> Please anybody tell me how to import string data by means of SQLLoader
in
> which the the newline character is included.
> The line in a text file looks like below:
>
> 10, 001, "The line which includes
> newline character", 1998
>
> I tried to use CONTINUEIF 0x0A or 0x0D but SQLoader doesnt take it.
>
> Thanks in advance
>
> --
> Jacek Pichla
>
>
Received on Thu Aug 16 2001 - 16:18:17 CEST

Original text of this message