Re: Change text in a table

On 24 Oct, 16:04, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Oct 24, 10:08 am, cqmman <cqm..._at_yahoo.co.uk> 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 Received on Wed Oct 24 2007 - 15:09:18 CDT