Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Change text in a table
Hello, I want to replace a portion of a string value in columns in a
table.
Lets say I have a table called TABLE_TEST with something like this:
value....................string value 1............................string1\string3 2............................string1\string4
I want it to be like this:
value....................string value 1............................string2\string3 2............................string2\string4
Will the following work?
UPDATE TABLE_TEST
SET string_value =REPLACE(string_value,'string1','string2');
I was also looking a SELECT REPLACE, but it seems like the above would
work?
Cheers
Received on Wed Oct 24 2007 - 09:08:45 CDT
![]() |
![]() |