title: Swap name in same same column in oracle
body: <p>In a table there is data.like this one</p>
  
  <pre><code>ID      NAME
  1   Apple
  2   Apple
  3   Apple
  4   orange
  5   orange
  6   orange
  7   Apple
  8   Apple
  9   Apple
  10  orange
  11  orange
  12  orange
  </code></pre>
  
  <p>data may be more then 1000 times. now there is need to swap/change/update apple to orange and orange to apple.</p>