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

Home -> Community -> Mailing Lists -> Oracle-L -> SQLLDR - whitespace (tab & space) problem

SQLLDR - whitespace (tab & space) problem

From: Helen Zhung <lannyue_at_yahoo.com>
Date: Fri, 27 Apr 2001 10:40:22 -0700
Message-ID: <F001.002F46DB.20010427104024@fatcity.com> 





I'm new to SQL Loader. Is there a way to code in control file that can separate 'a tab' and 'a blank space' ?
I use "FIELDS TERMINATED BY WHITESPACE", but it will TERMINATE a field when there is a space or a tab. However, the data fields were separated only by the "tab", not 'a space'. Is it possible to identify the two?
Thanks


 Do You Yahoo!?


Yahoo! Auctions - buy the things you want at great prices
Received on Fri Apr 27 2001 - 12:40:22 CDT












Original text of this message













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