title: Generating Random Number In Each Row In Oracle Query
body: <p>I want to select all rows of a table followed by a random number between 1 to 9:</p>
  
  <pre><code>select t.*, (select dbms_random.value(1,9) num from dual) as RandomNumber
  from myTable t
  </code></pre>
  
  <p>But the random number is the same from row to row, only different from each run of the query. How do I make the number different from row to row in the same execution?</p>