/ Published in: PL/SQL
This compares selected columns between 2 tables that you think might have differences. It lists the rows and values that are different between the two sources
You can add WHERE clauses as appropriate. You could also use this to compare the results of two queries.
This is from Tom Kyte (www.asktom.com). I can't say I understand exactly how it works, but it's much faster than other methods I've seen. It has the advantage of only looking through each table once.
You can add WHERE clauses as appropriate. You could also use this to compare the results of two queries.
This is from Tom Kyte (www.asktom.com). I can't say I understand exactly how it works, but it's much faster than other methods I've seen. It has the advantage of only looking through each table once.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
first_name, last_name, city FROM old_addresses