Hi,
I am trying to read a sequential file with multiple columns. The total number of columns depend on the value in first column. Then take the values from the columns and load it into Oracle tables.
Say, (as given below) if first column value is A1 there will be 5 columns or if it is A2 there always 3 columns
A1,c2,c3,c4,c5
A2,b2,b3
What would be the efficient way to read this file and load to a table
Appreciate your suggestions.
Thanks
Read flat file with multiple columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact: