Hello:

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

Reply via email to