Compare identical tables and return the difference
Posted by:
fresh3_16
Date: May 18, 2005 08:36AM
Hello,
I am trying to compare to Idential tables to get the records that are different, is there any query that I can use to accomplish this? Or do I have to parse each table separately.
eg.
Table 1 Table 2
------------ --------------
Name Name
Number Number
Address Address
So the query should only return the name, number and address that are not present in both tables
Thanks in advance
Subject
Written By
Posted
Compare identical tables and return the difference
May 18, 2005 08:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.