title: How to get delta records using pure SQL?
body: <p>I have two tables T_Person and T_Person_New in Oracle SQL.</p>
  
  <p><a href="https://i.stack.imgur.com/qpmmH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qpmmH.png" alt="enter image description here"></a> </p>
  
  <p>For ease, lets take <em>Name</em> as the unique identifier of both tables.</p>
  
  <p>Can i Compare both tables to get the delta records using an SQL query?</p>
  
  <p>The delta records should consist of the following condition:</p>
  
  <ol>
  <li>If it is a change in an existing record. I.e. a change in DOB / Gender / Name</li>
  <li>If its a new record.</li>
  </ol>
  
  <p>Thanks.</p>