Has toad have any tools for comparing oracle queries?
If you mean comparing...
-
... the syntax of the queries,
then you can perform that kind of Compare by either
(a) Right-clicking within an Editor tab and choosing Compare To (another Editor tab or file contents) per snap below.
(b) Via the pull-down menu Utilities-> Compare Files. -
... the resulting data from two queries,
then there's a few options I've had luck with...
(a) Copying/pasting the result sets of query 1 and query 2 to the left and right sides, respectively, of the Compare Files Viewer, or
(b) Creating views for each of the queries, and then use Database-> Compare-> Data from the pull down menu.
BTW, to the Quest Dev team,
it would be nice to right-click on the query's data grid (in the Editor) and Compare-To other data grids from other Editors/Tabs. Toad Data Point can do this, for example.
Thanks @Gary.Jerep good idea.
It shouldn't be too hard to modify the compare data window to let user enter SQL. I'll add this to beta soon.
-John