title: Bulk update a column in Oracle 11G
body: <p>I have two tables say Table1 and Table2 that contains the following column with which I should join and perform an update a column of Table1 with the value of the same column present in Table2.</p>
  
  <p>Columns for Join condition:</p>
  
  <ol>
  <li>Table1.mem_ssn and Table2.ins_ssn</li>
  <li>Table1.sys_id and Table2.sys_id</li>
  <li>Table1.grp_id and Table2.grp_id</li>
  </ol>
  
  <p>Column to update:</p>
  
  <p>Table1.dtofhire=Table2.dtofhire</p>
  
  <p>I need a way to bulk update (using single update query without looping)  the above mentioned column in Oracle 11G.</p>
  
  <p>Table1 does not contain any key constraint specified since it will be used as a staging table for Data upload.</p>
  
  <p>Please help me out to update the same.</p>