Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.chReceived on Tue Sep 16 2003 - 15:37:18 CDT