title: Updating > 1000 records in SQL
body: <p>I'm currently trying to perform more than 1000 update statements in preparation for migrating data from one table to another in our Oracle DB.</p>
  
  <p>I have a script which currently loops through all the records which will be affected with the column that will be updated and prints out each individual update statement... (ex. below)</p>
  
  <pre><code>UPDATE F_ASSET SET ZONE = 'Green/EHNET' WHERE ID = 3;
  UPDATE F_ASSET SET ZONE = 'Green/EHNET' WHERE ID = 1319;
  UPDATE F_ASSET SET ZONE = 'Green/EHNET' WHERE ID = 1324;
  UPDATE F_ASSET SET ZONE = 'Green/EHNET' WHERE ID = 1329;
  UPDATE F_ASSET SET ZONE = 'Yellow/IDMZ' WHERE ID = 1332;
  UPDATE F_ASSET SET ZONE = 'Green/EHNET' WHERE ID = 1333;
  UPDATE F_ASSET SET ZONE = 'Green/EHNET' WHERE ID = 1344;
  UPDATE F_ASSET SET ZONE = 'Green/EHNET' WHERE ID = 1359;
  UPDATE F_ASSET SET ZONE = 'Green/EHNET' WHERE ID = 1361;
  ....
  </code></pre>
  
  <p>I'm trying to find the best way of running all of these update statements (or some entirely different method) w/o having to bog down performance or group up a set of statements and run them in chunks.</p>
  
  <p>Any help will be greatly appreciated.</p>