Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compare data in two Oracle tables

705455Oct 2 2009 — edited Oct 5 2009
Hello,

What is the best way to compare data in two identical tables?

I have table A and table B, there are around 40 columns in each table with the same columns name and the same columns type. Now if any record in any column in the table A is different from the record for that same column in the table B, then I need to send this unmatched value with the entire row from table B to a client.

I basically need to convert a SQL Server SP to Oracle. The current SQL Server SP combines all records per row into a parameter, and uses SQL Server HashBytes function to compare. Is there a similar function in oracle?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2009
Added on Oct 2 2009
5 comments
21,041 views