title: What is the difference between INTERSECT and MINUS
body: <p>What is the difference between <code>INTERSECT</code> and <code>MINUS</code> in Oracle?</p>
  
  <p>Please explain with simple example.</p>
  
  <p><strong>Example data:</strong></p>
  
  <pre><code>select a_address from a1
  </code></pre>
  
  <p>Returns:</p>
  
  <pre><code>America
  California
  Japan
  </code></pre>
  
  <p>And</p>
  
  <pre><code>select a_address from a2
  </code></pre>
  
  <p>Returns:</p>
  
  <pre><code>England
  America
  WestIndies
  </code></pre>