Re: How to get SQL Loader to skip a column in a CSV file?

A copy of this was sent to "Micko" <micko_at_one.net.au> (if that email address didn't require changing) On Mon, 2 Aug 1999 11:20:43 +1000, you wrote:

>I want to get SQL loader to skip a column in a CSV file I'm loading. At the
>moment I am using a workaround based on the POSITION (*+n) because I can
>currently ensure that the field I want to skip always has the same width;
>this will not be the case in production. Have gone through the manual but no
>dice - help!
>

Oracle8i, release 8.1 does this with the keyword "FILLER". For before that see

http://www.deja.com/[ST_rn=ps]/getdoc.xp?AN=483755757&fmt=text

for one way to do it with sqlldr.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Aug 02 1999 - 06:05:05 CDT