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 relace tokens in a CLOB filed

Re: how to relace tokens in a CLOB filed

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 18 Dec 2002 09:14:42 -0800
Message-ID: <3E00AD02.206496AA@exesolutions.com>


hbz123 wrote:

> Hi,
> I am new to Oracle. I really need your help:
>
> I need to manuplate some data which has CLOB data type. I need to look
> through each CLOB and replace all the tokens say "_CEE_" with a new line
> return, and update or create a new table with the new value. I know i
> can use DBMS_LOB.INSTR to find the occurrences of the tokens, but i am
> not quite sure about the sytax to loop through the clob string and do
> the substitute.
>
> Thank you in advance!
>
> hbz123
>
> --
> Posted via http://dbforums.com

You will need to parse the clob excising the offending string and then put it back together again. You can not use TRANSLATE or REPLACE.

Daniel Morgan Received on Wed Dec 18 2002 - 11:14:42 CST

Original text of this message

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