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

On Oct 24, 10:08 am, cqmman <cqm... (AT) yahoo (DOT) co.uk> wrote:
Why ask when you can try the statement?

If you do not want to update the target table till you know for sure
your solution is working then either create some test data and try it
in test or create some test tables with a little sample data and try
it.

There is also the rollback command to prevent making the change
permanent, providing you are not using a tool with autocommit set on.

HTH -- Mark D Powell --

On 24 Oct, 16:04, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote:


Well yes good point. But I am not an expert in Oracle so don't want to
go around creating tables and stuff in a live DB (god knows how to
create a new Oracle DB, I don't without hitting the manuals!!).

I did actually try it using TOAD but couldn't see any useful output,
but I think that was because I the string I was looking for didn't
exist in the first place in that table..

Cheers

On Oct 24, 4:09 pm, cqmman <cqm... (AT) yahoo (DOT) co.uk> wrote:
Just select from the table and browse the results. Then pick some
strings that are there and write some queries to perform the desired
changes in the select list so the only thing you change is what is
displayed.

No need to actually update the data to see the effects of the
functions.

Oracle Express is free and pretty much self-installs. It will run on
regular Windows XP or Linux.

HTH -- Mark D Powell --