I am trying to insert data into table from an text file. One of my field is having carriage returns in between such as given below :-
This is the
test data and we
cannot work with it
suppose the data field name is description. My problem is when I am using the following control file to load the data in sqlldr :-
INTO TABLE JOBS
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
with the above control file it is not loading the data properly in description field all other fields it is loading data for first record. Wherever carriage returns are there in description field its breaking the information and taking data to new record in the first field such as reqnum. Can anybody help me out from this problem.