Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> replace text
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
![]() |
![]() |