I am trying to load csv file with sql loader but failing for the rows tha contains carriage returns. I can I process the rows with carriage returns. Tried multiple solutions found online but none of them working.
Here is my control file:
INTO TABLE TEMP_TEST
FIELDS CSV WITH EMBEDDED TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
the csv file have field called TEXT_NOTES with text spanning across multiple lines.
Please let me know.