title: Oracle update single table with multiple WHERE clauses
body: <p>Just been doing some migration of data in our 11g and found a situation, where I would normally just create a few separate UPDATE scripts and got to thinking. Is there a way to do multiple updates with different WHERE clauses in the same script?</p>
  
  <p>I mean instead of </p>
  
  <pre><code>UPDATE table1 SET value1=X WHERE value1=A;
  UPDATE table1 SET value1=Y WHERE value1=B;
  UPDATE table1 SET value1=Z WHERE value1=C;
  </code></pre>
  
  <p>Could you do something nearer</p>
  
  <pre><code>UPDATE table1 SET value1=X WHERE value1=A,SET value1=Y WHERE value1=B, SET value1=Z WHERE value1=Z;
  </code></pre>
  
  <p>Obviously the above syntax is wrong, but that's my point. Can something like this be done, or do you just have to do the three separate scripts?</p>
  
  <p>Thanks in advance</p>
  
  <p>KS</p>