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

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 Wed Apr 23 2003 - 22:02:16 CDT