title: Oracle SQL - Generate and update a column with different random number in every row
body: <p>Need help with SQL - I want to generate and update a column in every row with a different random number.</p>
  
  <p>Database # Oracle 10g.</p>
  
  <p>Example - When I do something like this it updates all the rows with the same number </p>
  
  <pre><code>update mytable r 
  set r.generated_num = 
  (select floor(dbms_random.value(100,9999999)) from dual).
  </code></pre>
  
  <p>Any advice? </p>