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 -> replace text

replace text

From: Jeff Kish <jeff.kish_at_mro.com>
Date: Fri, 05 Mar 2004 17:52:37 -0500
Message-ID: <u01i40lfsmmm5n7grp40g0sa5ekmr5ptok@4ax.com>


Greetings.

I can't figure out how to use replace.. maybe I'm looking at it wrong.

I need to replace all occurrences of 'abc1' with 'abc2' in columns fitting a where clause (like this I imagine for table 'myAttributes': replace ('abc1','abc2) in myAttributes where column1 = 'mycolumn1' and column2 = 'mycolumn2')

Can someone tell me the right way to do this?

Thanks
Jeff Kish Received on Fri Mar 05 2004 - 16:52:37 CST

Original text of this message

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