strip out characaters during sqlldr

  • From: "John Dunn" <JDunn@xxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 Mar 2007 10:40:12 -0000

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.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007