Re: SQL Loader: variable length records

Tom Kyte posted a package, called delimit, which enables you to select the fields you want from your loading file. If you scan this newsgroup, it should be here somewhere (unless he reads this and reposts it). Thread should be about a week old.

Mark.

CJ wrote in message <375410BA.27D98AA4_at_ix.netcom.com>...
>I have a file with 91 variable width fields separated by a ','. My
>problem is that I only
>need 9 of them which are interspersed within the records. For example
>I only want to load fields 4,9,20, 22, 33,55,71,78, and 90. I've been
>looking
>for an example of how to do this but they all assume that you will be
>loading
>every field in the file. How do I select just the fields that I need?
>
>TIA
>
Received on Wed Jun 02 1999 - 03:07:34 CDT