Re: Skipping variablye-length fields with sql*loader

[Quoted] It's possible with Oracle9i with the heyworld FILLER but FILLER doesn't exist in v8.

[Quoted] In past I used a solution :

    -add columns
    - load unused fields in columns added
    - drop columns

It's not so good for physocal storage but ...

[Quoted] "Wolfgang Neff" <w.neff_at_tirol.com> a écrit dans le message news: 3b55c9a3$0$28394$6e365a64_at_newsreader02.highway.telekom.at...
> I've got an automatically generated list. Its fields are separated by
> semicolons:
>
> 1098;"Graber Jürgen";"05442";"64674";"Flieáerau 373";;"Fliess";"6521";;;;
> 1272;"Küchl Franziska";"0664";"4825179";"Aigling
> 29";;"Oberperfuss";"6173";;;;
> 1355;"Tilg Silvia";"05232";"81071";"Wiesgasse
 1G";;"Oberperfuss";"6173";;;;
>
> I need to insert field 7 and 8 into a table. If there weren't the six
> leading fields the solution for the control file would look like that:
>
> LOAD DATA
> INTO TABLE Localita
> FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
> (
> Locali_K CHAR(40),
> CapLoc CHAR(5)
> )
>
> How can I skip the leading fields?
>
> Thanks so far
>
> Wolfgang
>
>
>
>
Received on Wed Jul 18 2001 - 20:18:05 CEST