title: Oracle : How to update multiple columns from different table?
body: <p>I am using oracle database and have a situations to update fields from some other tables. My issue is it is updating all the records instead of specified conditions.
  For example, I am trying to update perm_address and temp_address in EMPLOYEE table from ADDRESS table. Right now, I am using below query. But, it is updating all the records.</p>
  
  <pre><code>UPDATE EMPLOYEE EMP
       SET (EMP.PERM_ADDRESS, EMP.TEMP_ADDRESS) =
            (SELECT ADDR.PERM_ADDR,ADDR.TEMP_ADDR
             FROM ADDRESS ADDR
             WHERE ADDR.ID=EMP.ADDRESS_ID
            );
  </code></pre>
  
  <p>In Oracle how to handle this situations? Normally, how to handle the update from multiple table into source table?</p>
  
  <p>Thanks in advance....</p>