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 -> sqlldr: how to ingore spaces in source file?

sqlldr: how to ingore spaces in source file?

From: Ed Wong <ewong_at_mail.com>
Date: 1 May 2003 11:11:25 -0700
Message-ID: <a5ae1554.0305011011.7d5bdc5b@posting.google.com> 





Hi,



I need to use sqlldr to load into a 3 column tables from a flat file. 
The flat file looks like below.  There are spaces within column.  How
can I tell sqlldr to ignore/trim the spaces in front and after the
data?


1       |       all     |       synonym
2       |       Bacteria        |       Bacteria <bacteria>





Thanks,


ewong
Received on Thu May 01 2003 - 13:11:25 CDT












Original text of this message













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