Re: Change text in a table
- From: cqmman <cqmman@xxxxxxxxxxx>
- Date: Wed, 24 Oct 2007 13:09:18 -0700
On 24 Oct, 16:04, Mark D Powell <Mark.Pow...@xxxxxxx> wrote:
On Oct 24, 10:08 am, cqmman <cqm...@xxxxxxxxxxx> wrote:
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
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.
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
.
- Follow-Ups:
- Re: Change text in a table
- From: Mark D Powell
- Re: Change text in a table
- References:
- Change text in a table
- From: cqmman
- Re: Change text in a table
- From: Mark D Powell
- Change text in a table
- Prev by Date: Re: Help with Tomcat & Oracle on localhost
- Next by Date: Health check for Oracle Database
- Previous by thread: Re: Change text in a table
- Next by thread: Re: Change text in a table
- Index(es):
Relevant Pages
|
|
