Re: sqlldr / new line?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 21 Feb 2003 09:04:29 -0800
Message-ID: <3E565C1D.4E505EDE@exesolutions.com>

Tino Korth wrote:

> hello,
>
> i'm using sqlldr to put a data (text) file into an oracle db.
> sqlldr has got problems with "new lines" in text-fields.
> how does i have to quote "new line"'s?
>
> the "problem dataset":
>
> 6,"2002-08-15 10:46:41","Test","Line1\nLine2\nLine3",0
>
> thanks!
>
> greetz from rostock, germany!
>
> tino

My recommendation would be to load it into a dummy table and then parse it with a stored procedure.

Daniel Morgan Received on Fri Feb 21 2003 - 11:04:29 CST