title: How to find unmatched rows in oracle without using set operator and join & also Query the unmatched column names for an particular row
body: <p>I'm working on two tables test1 and test2 
  I have to find the matched, unmatched, values in table test1 not in test2 ... vice versa </p>
  
  <p>Then I have to do union of all the queries to get the final result. </p>
  
  <p>But I'm having problem with unmatched part. With set operator I'm getting wrong result set when I compared it with excel sheet data then I'm getting 15 extra rows </p>
  
  <p><strong>Note: there is no common column in both tables</strong> </p>
  
  <p><strong>Table:test1</strong></p>
  
  <pre><code>a     b        c
  2001  abc    john
  2008  cab    sam
  2002  qwe    mike
  2002  asd    samuel
  2012  ddd    sammy
  </code></pre>
  
  <p><strong>Table:test2</strong></p>
  
  <pre><code>a      b      c
  2001  abc    john
  2008  c@b    saam
  2009  qwe    mike
  2002  asd    samuel
  2001  a bc   john
  </code></pre>
  
  <p><strong>Output:</strong></p>
  
  <p>unmatched rows from table test1 or test2 <em>here I'm assuming test2</em></p>
  
  <pre><code>a        b      c      column_name
  2008    c@b    saam      a,b
  2009    qwe    mike    null
  2001    a bc   john      b
  </code></pre>
  
  <p>I want the above output with the <strong>unmatched rows</strong> from the both table  and column_names.</p>
  
  <p><strong>Column_names</strong> contains the name of the columns which are unmatched in a particular row.</p>
  
  <p><strong>My query (using minus )</strong></p>
  
  <pre><code>Select t2.a, t2.b, t2.c from
  (Select a,b,c  from test1 t1
   Minus  
  Select  a,b,c  from test2 t2)
  </code></pre>
  
  <p><strong>For column_name my logic was</strong>: </p>
  
  <pre><code>Case when t1.a !=  t2.a then 'column a name' 
  When t1.b 1= t2.b then 'column b name' 
  
   *....And so on .....*
  </code></pre>
  
  <p>But I think it can be done with the help of join that what I <strong>don't want</strong></p>
  
  <p>I am using Oracle 12c.</p>