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

rss_at_ddsc.com (Robert Silver) 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.

I can see
- no version
- reference to a package, dbms_lod, which doesn't exist, and should read dbms_lob
- inability to see 'replace' could be done with dbms_lob.instr and dbms_lob.substr
- whining in a newsgroup where the complaints should be directed to the vendor, Oracle

so YES, you are probably better of by using a toy like Microsoft Access.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Apr 24 2003 - 02:29:16 CDT