Re: Change text in a table

On Oct 24, 4:09 pm, cqmman <cqm..._at_yahoo.co.uk> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

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 -- Received on Fri Oct 26 2007 - 18:34:33 CDT