Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Loader: variable length records
Write a c program to strip out the unwanted fields.
Not Ideal, but it is quick and will work.
CJ wrote:
> 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 Thu Jun 03 1999 - 09:48:18 CDT
![]() |
![]() |