This compares selected columns between 2 queries, using the WITH clause. It lists the rows and values that are different between the two sources.
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, because it only looks through each query once.
You need to login to post a comment.