Re: Compare identical tables and return the difference
In this case only the primary key. Off the top of my head, you could join all the fields then check for nulls across all the fields with one long WHERE statement joined by OR. Seems like it wouldnt be very efficient but I dont know of a way to compare records.
Subject
Written By
Posted
Re: Compare identical tables and return the difference
May 20, 2005 09:03AM
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.