Re: Using replace in a clob

Just as long as you have 9i + RDBMS

Mike

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:F4adnZQNfp-olN3fRVn-qw_at_comcast.com...
>
> "CE" <charlie3101_at_hotmail.com> wrote in message
> news:1111492492.454984.294190_at_o13g2000cwo.googlegroups.com...
>> Hi,
>>
>> Somebody's come to me with a little problem that I know is solveable,
>> but I'm not sure of the best way.
>>
>> They've got a load of clobs and within each clob they want to do a
>> series of global text changes, (all to do with them changing the names
>> of substitution variable in some kind of template - it's some kind of
>> php development). So for example, they want to change the string
>> "{date1}" to "{date1:date}".
>>
>> Now obviously this is trivial in a VARCHAR2 setting, but we're talking
>> about a clob.
>>
>> So what's the best way? I thought about cutting it up into chunks
>> using DBMS_LOB.SUBSTR, then doing the replace and putting it all back
>> together at the end. There is the problem if my target string happens
>> to span the end of one of the substrings.
>>
>> Has anybody got any ideas/suggestions?
>>
>> TIA
>>
>> CE
>>
>
> why not just use REPLACE()?
>
> ++ mcs
>
Received on Wed Mar 23 2005 - 00:40:40 CST