title: Oracle SQL technique to avoid filling trans log
body: <p>Newish to Oracle programming (from Sybase and MS SQL Server).  What is the "Oracle way" to avoid filling the trans log with large updates?</p>
  
  <p>In my specific case, I'm doing an update of potentially a very large number of rows.  Here's my approach:</p>
  
  <pre><code>UPDATE my_table
  SET a_col = null
  WHERE my_table_id IN 
  (SELECT my_table_id FROM my_table WHERE some_col &lt; some_val and rownum &lt; 1000)
  </code></pre>
  
  <p>...where I execute this inside a loop until the updated row count is zero,</p>
  
  <p>Is this the best approach?</p>
  
  <p>Thanks,</p>