Does anyone know how to specify a row delimiter other than carriage return with SQL Loader? I want to specify a double quote followed by carriage return as the delimiter. The problem that I'm having is someone will type a CR in a comments field and sql loader will think its a new row.
"field1", "comments field", "last field"<CR> --- THis works ok
field", "last field"<CR> --- This fails because it looks like 2 rows
If I could specify "<CR> as the row delimiter, I think sql loader would ignore the <cr> in the comments since it doesn't have a " before it.