Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader: variable length records

Re: SQL Loader: variable length records

From: Keith Jamieson <pdkj02_at_email.mot.com>
Date: Thu, 03 Jun 1999 15:48:18 +0100
Message-ID: <375695B2.6131CA62@email.mot.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US