Re: Control File problem

> Hi,
>
> I have a csv file that has values as given below:
>
> ,F100,F101,F102
> 1000,X,X,
> 1002,X,,X
>
> I need to load this data in the table structure as below
>
> Name Null? Type
> ------------------------------- -------- ----
> POSTE_ID VARCHAR2(6)
> ELEMENT_ID VARCHAR2(6)
> ELEMENT_VALUE VARCHAR2(1)
>
> where the data should be populated as below:
>
> POSTE_ID ELEMENT_ID ELEMENT_VALUE
> ---------------- ----------- ---------------
> 1000 F100 X
> 1000 F101 X
> 1000 F102
> 1002 F100 X
> 1002 F101
> 1002 F102 X
>
> Could anybody help me with writing the control file. However, if there
> is any different way in which it could be done, you are welcome

Amit,

Additionally to sql*loader and utl_file, you might as well consider external tables (if you're on 9i).

See http://www.adp-gmbh.ch/ora/misc/ext_table.html for more details.

Hth,
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch