One of the TOAD gurus recommended me to use this product to compare datasets.
My goal is to be able to compare either tables (with the where clause) or ideally queries from different sources. I am interested in the different rows (which is easily achievable using minus or varaios outer joins), but also in different columns (which is somewhat difficult).
When i tried to use the trial version of this product i did not find a way to compare a single table (with the where clause), it forced me to load all objects for the schema and it simply blew up (i assume because the particular schema has a lot of objects, thousands).
Am i missing something? Is there a simple way to compare result sets?