Comparing two rows in Oracle DB and Showing Column Mismatch
<p>Table Columns: Id, Name, Age</p>

<p>First Rows:</p>

<pre><code>select 11, 'James', 22 from dual;
</code></pre>

<p>This will return </p>

<pre><code>11 James 22
</code></pre>

<p>Second Row:</p>

<pre><code>select * from supplier where id=11`;
</code></pre>

<p>This will return</p>

<pre><code>11 Vinod 25
</code></pre>

<p>Now I wanted to compare both rows:</p>

<pre><code>11 James 22
11 Vinod 25
</code></pre>

<p>It should return the columns which has differences.</p>

<blockquote>
  <p>Name Mismatch
    Age Mismatch</p>
</blockquote>

<p>I am using 12c is there Built in feature in oracle which will solve this.
Or any other ways from which I can achieve the solution for the same.</p>

<p>Thanks In advance..</p>

<p>`</p>