sqlldr: how to ingore spaces in source file?
From: Ed Wong <ewong_at_mail.com>
Date: 1 May 2003 11:11:25 -0700
Message-ID: <a5ae1554.0305011011.7d5bdc5b_at_posting.google.com>
Hi,
Date: 1 May 2003 11:11:25 -0700
Message-ID: <a5ae1554.0305011011.7d5bdc5b_at_posting.google.com>
Hi,
[Quoted] [Quoted] 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 - 20:11:25 CEST