In my code I have the following

Case var
When value_1 update fielda = var where condx
When value_2 update fieldb = var where condx
....
When value_x ....

In resume I need to update a certain field of a table base on a value always with the same where clause.

If I have 100 values, I need to write a 100 update statements. Is there another way to do this?

Merci / Thanks
Yves Leonard,
Chef de Projet / Project Leader,
DDS / SDD,
RH Coats, 13-I
Téléphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]



Oracle LazyDBA home page