Re: how to translate a clob?

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)