Re: Skipping variablye-length fields with sql*loader

In article <9j4k1f$hpa$1_at_wanadoo.fr>, "Patrick says...
>
>It's possible with Oracle9i with the heyworld FILLER but FILLER doesn't
>exist in v8.
>

FILLER was added in 8i, before 9i. Versions 8.1 and up have that.

>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 ...
>

but, since drop column wasn't added until 8i either -- how'd you manage that?

see
http://osi.oracle.com/~tkyte/SkipCols/index.html for some solutions.

>"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
>>
>>
>>
>>
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp