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

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a way to specify a record delimitor for SQL*Loader rather than accepting the default LF CR?

Re: Is there a way to specify a record delimitor for SQL*Loader rather than accepting the default LF CR?

From: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Mon, 20 May 2002 15:18:10 -0600
Message-ID: <3CE96812.E333A834@noaa.gov> 





Yes, there is.  Look into the STR clause in the SQL*Loader control
file.  For your reading entertainment, here is a clause that I used
when using SQL*Loader contained on my Win2000 server installation
to load data that I suspect originated on a Unix machine.  Do some
experiments on your end.



Here's the sample:


<snip>


INFILE 'g:\8pafir8x.txt' "str X'0d0a'"


<snip>



TG



Mark wrote:



> Is there a way to specify a record delimiter for SQL*Loader rather than

> accepting the default LF CR?

Received on Mon May 20 2002 - 16:18:10 CDT












Original text of this message













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