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: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Thu, 24 Apr 2003 00:02:03 -0700
Message-ID: <3EA78BEB.916B7BE3@exxesolutions.com>


Robert Silver wrote:

> 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.

Take a look at DBMS_SQL. A few more hours of research and you may have no problem doing it.

Oh and anytime you can get MS Access to read and edit a 4GB text object ... please let Bill Gates know as that will be news to him.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
(remove one 'x' from my email address to reply)
Received on Thu Apr 24 2003 - 02:02:03 CDT

Original text of this message

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