Re: Sql*Loader: Loading fields containing newlines from a data file
From: Mike Madland <mikemad_at_asymetrix.com>
Date: 1996/08/08
Message-ID: <4udi4k$2o_at_loki.asymetrix.com>#1/1
Date: 1996/08/08
Message-ID: <4udi4k$2o_at_loki.asymetrix.com>#1/1
P.German_at_integrity.nl (Peter German) wrote:
[snip]
>I've tried to replace the newlines and load the data into Oracle and
>it works. But the data is put into a field of type LONG so I can't use
>the function replace(), it's only for CHAR and VARCHAR2.
>I'm very surprised about the fact that it is so difficult to insert
>ASCII-text data into Oracle.
>Peter.
You can write a (quick?) PL/SQL block to loop through the table, put the long into a varchar2(32767) and use replace on the varchar2, then update the long. I've tried this and it works with no problems. It does limit your longs to 32767 though...
Mike Received on Thu Aug 08 1996 - 00:00:00 CEST