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 -> Change text in a table

Change text in a table

From: cqmman <cqmman_at_yahoo.co.uk>
Date: Wed, 24 Oct 2007 07:08:45 -0700
Message-ID: <1193234925.512587.205230@z24g2000prh.googlegroups.com>


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

Original text of this message

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