Control File problem

From: Amit Saha <da_saha_at_yahoo.com>
Date: 16 Sep 2003 07:52:12 -0700
Message-ID: <7851859c.0309160652.11a91abb@posting.google.com>

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

Thanks
Amit Received on Tue Sep 16 2003 - 09:52:12 CDT