Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sqlldr: how to ingore spaces in source file?
Hi,
I need to use sqlldr to load into a 3 column tables from a flat file. The flat file looks like below. There are spaces within column. How can I tell sqlldr to ignore/trim the spaces in front and after the data?
1 | all | synonym 2 | Bacteria | Bacteria <bacteria>
Thanks,
ewong
Received on Thu May 01 2003 - 13:11:25 CDT
![]() |
![]() |