Control File Problem
From: Amit Saha <da_saha_at_yahoo.com>
Date: 16 Sep 2003 07:53:41 -0700
Message-ID: <7851859c.0309160653.5a718d61_at_posting.google.com>
Hi,
I have a csv file that has values as given below:
ELEMENT_ID VARCHAR2(6)
ELEMENT_VALUE VARCHAR2(1) where the data should be populated as below:
1000 F101 X
1000 F102
1002 F100 X
1002 F101
1002 F102 X
Date: 16 Sep 2003 07:53:41 -0700
Message-ID: <7851859c.0309160653.5a718d61_at_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 - 16:53:41 CEST