Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: sql*loader and escaped data

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@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 - 10:17:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US