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: I found a work around for now but - anyone know how to do a replace upon Clob ??

Re: I found a work around for now but - anyone know how to do a replace upon Clob ??

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Thu, 24 Apr 2003 13:45:56 GMT
Message-ID: <kURpa.68140$Si4.55511@rwcrnsc51.ops.asp.att.net>


I spent 2 hours once and created a replace function for Clobs. It involved making a temporary lob (due to the change in the size and position of stuff in the lob when you do the replace - assuming the replace is a different size than what is being replaced.). So read the docs and go at it.I could probably do it for you for $1,000 cash.
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Robert Silver" <rss_at_ddsc.com> wrote in message
news:259cff91.0304231821.213f7bae_at_posting.google.com...

> I just spent hours scouring the news groups looking for what I thought
> was a simple script or package.
>
> I have a tip for anyone struggling with the same problem. Get
> MS-ACCess
> attach via ODBC and do the job by linking tables and doing a search
> and replace
> edit on the table.
>
> Now Oracle should have a DBMS_LOD. function equal to REPLACE in
> standard SQL.
>
> One would hope the folks at Oracle would have the sense to make
> functions that work with all datatypes or at least have complete sets
> of both functions
> If there is a INSTR and a SUBSTR function in Oracle under the DBMS_LOD
> functions why can there not be a replace function and please note I
> have been
> trying to find all table rows with ' character in it. Again This also
> seems impossible as the '' strategy does not work e.g
>
> although the contains function works great on non quote entries the
> following does not work as expected if you belive '' is treated as '
>
> select dn from bigtest where contains(bigfield,'''')>0;
>
> this does not work I have tried it. Theoretically it should work but
> nope does not work.
>
> Also So far I have found no script to get the job of REPLACE and by
> the way
> they should think about renaming it anyway since replace function as a
> internet search term picks up all teh function creating scripts on the
> planet
>
> Maybe REPLACESTR because as I said too many hits for function with
> just replace.
>
> Anyway a script to do this would be nice. If I get a chance perhaps I
> will post one myself. If anyone has such a script Much thanks. If not
> buy Microsoft access
> at least a cheaper product works to solve the problem.
Received on Thu Apr 24 2003 - 08:45:56 CDT

Original text of this message

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