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!

finding delta between two tables.

748152Sep 1 2010 — edited Sep 2 2010
every day, I have a full table loaded in a schema.

there is a copy from yesterday and from today.

what is the best way to compare the contents of the two to see if there is any differences?

table is in 10 million rows, and 40 columns wide, with no index.

thanks.

Edited by: user1035690 on Sep 1, 2010 9:38 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2010
Added on Sep 1 2010
5 comments
4,485 views