Re: sqlload and newlines [message #368096] |
Mon, 20 March 2000 05:36 |
Thomas
Messages: 67 Registered: September 1999
|
Member |
|
|
Hi Jim,
I faced that problem before. Here is what Oracle
Support told me: Create a c-prog to convert the
origin cr-lf to s.th. like YYYXXX. Load the stuff
and convert it back to cr-lf. Only this workaround
is possible.
Because I unloaded the data from an Oracle Table
I used the replace command in sql
REPLACE(char,search_string[[,replacement_string]])
to do the conversion.
regards Thomas
|
|
|