Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: long to clob?

Re: long to clob?

From: arthex <arthex_at_wanadoo.fr>
Date: Fri, 29 Oct 1999 19:35:34 +0200
Message-ID: <3819DAE6.4DFA4FA3@wanadoo.fr>


With Oracle 8i (8.1.5) you can use the function TO_LOB

vtsien wrote:

> Does anybody know how to convert a long data type column into clob? The
> data inside long contains many catrige returns(as a result of doc cut and
> paste). Therefore you cannot dump it out as text file and loaded in as
> clob.
>
> Vic
Received on Fri Oct 29 1999 - 12:35:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US