title: How to update a table column with random values within a range in Oracle?
body: <p>I have a table with 3 columns: 
   - <code>PRIMARY_KEY</code>
   - <code>AMOUNTS</code>
   - <code>RAND_AMOUNTS</code> (all nulls)</p>
  
  <p>I want the <code>RAND_AMOUNTS</code> column to be populated with following formula: </p>
  
  <pre><code>AMOUNT*(0-100 random value)/100
  </code></pre>
  
  <p>So for example if the amount row let us suppose is 10 and the random value generated for the row is 10 then <code>RAND_AMOUNT</code> should be <code>10 * 10 / 100 = $1</code></p>