Yves,
What are you looking for?
A way to have the 100 updates generated for you
Or a way to avoid doing the update 100 times?

- a

-----Original Message-----
From: Yves [mailto:oracledba-ezmlmshield-x24507049.[Email address protected]
Sent: Thursday, April 28, 2005 11:08 AM
To: LazyDBA Discussion
Subject: Simplifying plsql code

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]




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page