title: Update table with a sequence of values
body: <p>I'm looking for a way to update an existing table with an ascending sequence of dates. Using this select works:</p>
  
  <pre><code>SELECT
      TO_DATE('01-MAR-15') + (rownum * 2)
  FROM all_tables
  WHERE rownum &lt;= 35
  </code></pre>
  
  <p>I cannot, however, use this in an update query. In Oracle, how could I write an update table statement similar to this?</p>
  
  <pre><code>UPDATE my_table
  SET my_date_column = (
      TO_DATE('01-MAR-15') + (rownum * 2)
  )
  WHERE my_keys IN (
      // my subquery here - select my_key from my_table where....
  )
  </code></pre>