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.