Can SQL Loader read newline chars - multiline column?
730474Oct 27 2009 — edited Dec 6 2012Hello All,
I am using SQL Ldr (Release 10.2.0.1.0) to load from a .csv file to a single table.
The .csv file however has a column which spans across multiple lines (with a newline chars).
Example below:
-----------------------
Record1:
A, B, "ABCD", "123"
Record2:
X, Y, "XY
Z", "456"
Record 3:
P, Q, "P
QR", "789"
-----------------------
Notice that record 2 & 3 has newline (it is not a word wrap)
My SQL loader treats each line as a new record!
I tried using the following in my control file but no avail
INFILE 'C:\xyz.csv' --"STR '\r\n'"
I also tried using the following for that particular column but with no use.
"REPLACE(:col_name,CHR(13) || CHR(10))",
Is there a way for this or is there a restriction on the SQLldr version or the Loader itself.
Someone please,
Thanks!