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 -> how to translate a clob?

how to translate a clob?

From: Isabelle Leroy <isabelle.leroy_at_enst-bretagne.fr>
Date: Fri, 1 Oct 2004 17:40:51 +0200
Message-ID: <cjjtk7$etr$1@matell.enst-bretagne.fr>


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 Received on Fri Oct 01 2004 - 10:40:51 CDT

Original text of this message

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