title: Copy data from one table to another- Oracle
body: <p>I have two tables namely PERSON and WIFE. I want to make WIFE's data available in PERSON table while keeping entries of WIFE maintained and at the same time adding some the values of PERSON against the data of wife.<br></p>
  
  <p><strong>PERSON Table</strong><br></p>
  
  <pre><code>    PK   NAME      ADDRESS    IS_MARRIED
      1  John        ab city     Y        
      2  Varvatos    cd town     N
      3  Smith       ef town     Y
      4  Henry       gh city     Y
      5  Lynda       gh city     Y
  </code></pre>
  
  <p><strong>WIFE table</strong><br></p>
  
  <pre><code>    PK  PERSON_ID (FK)    NAME         
      1    1                 Alice
      2    3                 Rosy
      3    4                 Lynda
  </code></pre>
  
  <p>Now i want to copy data of WIFE table into PERSON table like this<br>
  <strong>PERSON table</strong></p>
  
  <pre><code>   PK   NAME      ADDRESS    IS_MARRIED
     1  John        ab city     Y        
     2  Varvatos    cd town     N
     3  Smith       ef town     Y
     4  Henry       gh city     Y
     5  Lynda       gh city     Y
     6  Alice       ab city     Y
     7  Rosy        ef town     Y
  </code></pre>
  
  <p>As in the given example you might have noticed that ADDRESS of wife is same as of her spouse and same goes for IS_MARRIED column. Moreover, the PK is also not duplicated. How to go about this?<br>
  <strong><em>*</em></strong><em>Edited</em><strong><em>*</em></strong><br>
  Another important factor is Lynda already exits in PERSON table, therefore, i certainly don't want to duplicate her entry. </p>