Home » RDBMS Server » Server Utilities » Re: sqlload and newlines
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
Previous Topic: Re: SQL*Loader and CGI
Next Topic: Re: Export errors.. sort of
Goto Forum:
  


Current Time: Thu Mar 28 15:41:00 CDT 2024