SQL Loader : Combine Multiple Lines from a datafile and load as one

Hi All,

As part of interface, we are trying to load the data from csv data file into oracle staging table using SQL Loader Control File.

One of the column in that Data file is Description. Data in the description column is something like below:

"Order raised to credit back overpayment against order 0543/1948Q.

Morning Ryan

 

Hope you are well.

Could you please raise a credit dummy number for the above job.

 

When we were completing works on this job, we were able to complete item 2 as a minor repair instead of a major, in which we had priced for.