The main question here is the length of your first two fields: Section and Book1. Is section a 2 character field and book 4 or is book 5 and section 1? Based on the data the appearance is that section can be 2 characters and book 4 but we can't infer this from the presented data is there sample row w/o any spaces?
–
xQbertMar 13 '13 at 12:12

You are right Section can be 2 characters but in the data set presented only 1 character is shown. Similarly Book 1 can be 4 but in this example set it is 3 only.
–
MonicaMar 13 '13 at 12:18

5 Answers
5

We can also use UTL files to extract data from flat files
and UTL files will extract data as string itself , so as you konw the lengths you
can use SUBSTR to extract the correct column values and then insert into temp table

You might like to consider using an external table instead of SQL Loader inserting to a temporary table, as you can more easily apply the SQL functions to the file data and split out the columns during the reading of the file.