SQL*LOADER - Question

From: Juan Carlos Rodriguez <juancarlos.rodriguez_at_ajterrassa.es>
Date: 3 Aug 1998 09:14:46 GMT
Message-ID: <01bdbec0$08a3e940$2102000a_at_px287>

Hello !

[Quoted] [Quoted] I have a problem loading data with SQL*LOADER. [Quoted] [Quoted] The datafile to load has 4 variable length fields terminated by commas. I only need two fields but they aren't contiguous.

For example, supose this data file:

1,"one","first","A"
2,"two","second","B"
3,"three","third","C"

...
We only need the columns 1 and 3, discarding the columns 2 and 4.

Any suggestion ?

Thanks a lot

Juan Carlos Rodriguez
D.B. Administrator Received on Mon Aug 03 1998 - 11:14:46 CEST