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