Re: Skipping Delimited Fields in SQL*Loader

A copy of this was sent to Brad McFarlane <bradm_at_newbridge.com> (if that email address didn't require changing) On Mon, 30 Aug 1999 09:01:36 -0400, you wrote:

>I'm new to using SQL*Loader, but there's something I'd like to do that
>doesn't seem to be in the Oracle on-line docs for SQL*Loader.
>

[snip]
>
>(e.g., if it came from some program that output a fixed set of fields)
>but the "emp" table was the same. What you need to do is tell SQL*Loader
>that "empno" is the first field, "ename" the second, "job" the fourth
>field, etc. In other words, SQL*Loader should skip the third (delimited)
>field on the line. With fixed-width data, it seems pretty easy to skip
>columns using POSITION to say which data columns go with which table
>column names, but I can't figure out how to say which data fields go
>with which table column names.
>
>Is this possible, and if so, how? If it isn't, I'll have to resort to
>stripping out just the columns I want before I feed the data into
>SQL*Loader.
>

see the website in my signature below. there is a short paper on howto skip fields with sqlldr.

>Any help would be appreciated.
>
>Thanks,
>Brad McFarlane

-- 
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