Re: Sql Loader and Carraige Returns
From: fumi <fumi_at_tpts5.seed.net.tw>
Date: Tue, 24 Apr 2001 22:11:39 +0800
Message-ID: <9c44n8$r97$1_at_news.seed.net.tw>
Date: Tue, 24 Apr 2001 22:11:39 +0800
Message-ID: <9c44n8$r97$1_at_news.seed.net.tw>
"rich ford" <ford1_at_wbbx.com> ????? news:3ADEF298.1F6CBA5D_at_wbbx.com...
> I am trying to load data using Sql Loader. A couple of the
> columns are VARCHAR2(4000) and contain carriage returns.
> So Sql Loader is interpreting the Carriage returns as
> End of Record.
>
> Any way around this?
You can use CONTINUEIF keyword in the control file. Take a look about "logical recods" on Oracle8 Utilities manual. Received on Tue Apr 24 2001 - 16:11:39 CEST