Oracle - difference or changes between two rows from two tables
oracle, oracle10g, plsql, sql
Solution
This SO answer provides a very efficient solution using Oracle to compare the results of 2 queries: Proving SQL query equivalency
Problem
I have two tables both have same schema, one will have previous day records other will have current. I want to compare both and find only changes or only rows that have different value in atleast one column. How is this possible in pl/sql, oracle? (I did code something similar using checksum in T-SQL but not sure how to do in pl/sql)