title: update table by giving old and new entry from query
body: <p>I select a list of old and new values for a table with a query:</p>
  
  <pre><code>select new, old from SOME_TABLE; 
  
  new         old
  ----------- -----------
  1174154     1064267743
  1174164     1072037230
  1174167     1065180221
  1174180     1071828953
  1174181     1067402664
  1174204     1073143287
  1174215     1057480190
  1174222     1061816319
  1174331     1072011864
  1174366     1061275972
  </code></pre>
  
  <p>now i need to update a table that contains these old values and replace them by the new 
  ones.</p>
  
  <pre><code>update OTHER_TABLE set some_column = &lt;newvalue&gt; where some_column = &lt;oldvalue&gt;
  </code></pre>
  
  <p>Is it possible to do this with one query or do i need to loop over the result tuples and update for each row?</p>
  
  <p>I <em>cannot</em> change the database layout or write a trigger that does this automatically...</p>