Updating a row in an Oracle table.

[joeythelips]

Hi,

I have an oracle table, with approx 10,000 records.
One field contains 52 different types of standing charges.
All of these standing charges have increased, although not at the same rate.
I have a list of all the new charges.
What is the best way to update, and if anyone had some sample code, it would be much appreciated.

Thanks for your time,

Joe

 

[THoey]

I think the easiest way might be to create a table with the standing charges type and the increase rate and then run an update query. Otherwise, you are going to have to use the DECODE statement, probably a bunch of them (57) to do it.

Terry M. Hoey

 

[joeythelips]

Hi Terry,

Unfortunately, the new rates were individually worked out, rather than a for example, 10 % increase placed on each one.