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