Hi,
I have a flat file which fixed length format file. Total length of each line is 1000 and Total no.of records are 50.
I want to split each line into 5 records based on the positions.
Example: 1. Taking the first line from flat file.
2. Position 1 to 100 should be in one row
3. Position 101 to 200 should be in second row
4. Position 201 to 300 should be in third row
5. Position 301 to 400 should be in fourth row
6. Position 401 to 500 should be in fifth row
7. Totally 300 records should be returned after creating External table and Querying the data from flat file.
8. I will need to load those records into a Oracle Table then.
Is the above scenario possible in External table?
If no, please suggest me an alternative solution to load the data from flat file to Table with above scenario.
Thanks in Advance,
Dinesh.