Re: Help: sql*loader and escaped data
From: Ivan Muravyov <imuravyov_at_dxi.com>
Date: Tue, 18 May 1999 15:17:17 GMT
Message-ID: <374184DF.FA2E20F6_at_dxi.com>
Date: Tue, 18 May 1999 15:17:17 GMT
Message-ID: <374184DF.FA2E20F6_at_dxi.com>
> Folks I have string with embedded \' as follows:
>
> 6721,'white shadow\'s stories',1
> 6733,'Net Cafe\'s',1
>
> sql*loader rejects these records. Is there a way to double
> escape this ??
Why not? Convert enclosing quotes to double-quotes and write in control
file:
....OPTIONALLY ENCLOSED...
Received on Tue May 18 1999 - 17:17:17 CEST