Delimited file load - URGENT [message #70434] |
Thu, 13 June 2002 06:35 |
Anush
Messages: 1 Registered: June 2002
|
Junior Member |
|
|
Hi,
I have the following questions on loading a table with data from a comma delimited file.
ex.
Table:
col1,
col2,
col3,
col4,
col5
Data:
1,2,3,4,5
2,3,4,5,6
Here is the mapping:
col1 -> sequence no (generated)
col2->field1
col3-> field2 or substr(field3,10,8) depending on the value of field1
col4 -> sysdate
col5 -> field4
Can anyone please give me the code to the control file.
Well, I'm used to fixed lenght files where I can map to any field by position, I have no idea how this can be done in delimited file.
Thanks in advance.
|
|
|
|