Re: SQL*Loader question

In <453t04$60i_at_cwis.isu.edu>, Joerg Senekowitsch <joerg_at_pharmacy.isu.edu> writes:
>Hello SQL*Loader wizards,
>
>we are trying to load data from a flat ASCII file into
>Oracle (7.1.4) with SQL*Loader.
>Our flat file contains delimited fields as records, e.g.
>
>"Field1...","Field2...","Field3...","Field4...",... etc.
>
>(FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"')
>
>How do we load ONLY fields 2 and 4 from SQL*Loader? All examples
>in the SQL*Loader manual assume FIXED length fields and use the
>POSITION(x:y) construct to refer to individual fields. How DOES one
>refer to individual fields that are of variable length and delimited?
>
>Thanks,
>
>Joerg
>

As long as the fields are comma terminated you need not to specify the length. To load 2 out of 4 fields you need to only specify what fields you want to load in the control file. Hope this help

HL

>============================================================
>Joerg Senekowitsch, Ph.D. <joerg_at_pharmacy.isu.edu>
>SysAdmin Phone: (208) 236-2627
>College of Pharmacy FAX: (208) 236-4421
>Idaho State University ------------------------
>Pocatello, Idaho 83209 I SPEAK FOR MYSELF !
>==================== mens agitat molem =====================
Received on Fri Oct 06 1995 - 00:00:00 CET