title: Bulk update with commit in oracle
body: <p>I am performing bulk update operation for a record of 1 million records. I need to COMMIT in between every 5000 records  how can I perform? </p>
  
  <pre><code>update tab1 t1
     set (col1,col2,col3,col4)= 
     (select col1,col2,col3,col4 from tab_m where row_id= t1.row_id);
  </code></pre>