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

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to translate a clob?

Re: how to translate a clob?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 01 Oct 2004 17:07:55 -0700
Message-ID: <1096675755.784735@yasure>


Isabelle Leroy wrote:

> Hello,
>
> I want to "translate" a Clob ("myfield") by doing this :
>
> update mytable
> set myfield = translate(myfield,'','''');
>
> But...it isn't possible to use "translate" on clob :-(
> I know there is the dbms_lob package which can help...
>
> Did someone solve this pb?
> Thanks in advance.
>
> Isabelle

Substring out 32K at a time as a VARCHAR2.

Take a good look at the DBMS_SQL package's ability to execute a PL/SQL table.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Oct 01 2004 - 19:07:55 CDT

Original text of this message

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