Re: sqlldr / new line?

From: FC <flavio_at_tin.it>
Date: Fri, 21 Feb 2003 17:56:43 GMT
Message-ID: <vLt5a.213033$0v.5954918@news1.tin.it>

"FC" <flavio_at_tin.it> wrote in message
news:Ywt5a.288589$AA2.10937134_at_news2.tin.it...
>
>
> The syntax would be like this:
>
> ...
> column_name CHAR ENCLOSED BY '"' "REPLACE(:column_name, '\\n',
> CHR(13) || CHR(10))"
>
> Caveat: this works if the column datatype is VARCHAR2, not CLOB.
>

or like this:

column_name CHAR ENCLOSED BY '"' "REPLACE(:column_name, '\\n', '\n')"

Bye,
Flavio Received on Fri Feb 21 2003 - 11:56:43 CST