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

Home -> Community -> Mailing Lists -> Oracle-L -> strip out characaters during sqlldr

strip out characaters during sqlldr

From: John Dunn <JDunn_at_sefas.com>
Date: Wed, 7 Mar 2007 10:40:12 -0000
Message-ID: <2F802216565E44489600A03F763219A81888A6@mia.SEFASBRISTOL>


I need to strip out all spaces from a string when loading data via sqlldr direct load.  

Is this possible? What would be the control file syntax?  

Needs to work in Oracle 8 and 9.        

John in transmission.    

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 07 2007 - 04:40:12 CST

Original text of this message

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