I’ll be using this tool with my co-worker developers as they try to learn Oracle, SQL, and how to best use Toad as they enhance their skills with Oracle development. Overall, I like the cleaner/tighter look of the Query Builder output in the Beta than with the 10.5 version. These joins correspond to where the BETWEEN function is being used. In the 10_5 file, I’ve highlighted the joins that are missing in the 11_1_0_20 file. This is the same query minus the comment (wouldn’t work in the 11 beta).

This doesn’t seem to be the case with the 10.5 commercial version of Toad.Ģnd issue: it looks like some of the joins are no longer being drawn. (looks like no joins at all are used in the query). None of the query after the comment is loaded nor processed, giving an inaccurate result. Seems that the query used is up to the point of the comment. (as a side issue: Seems to take longer on the initial call (after startup) to paint the screen. Imbedded in the query is a single comment. Attached is a DDL file to create my testcase tables, the 2nd file is the query to use.

I’ve got two issues to point out with Query Builder.

Toad for oracle query builder