July 2015
Intermediate to advanced
288 pages
7h 26m
English
Toad has a nice Query Builder feature. This feature enables SQL code to be built using mouse operations. This feature is excellent for power users, analysts, and managers using Toad to create reports and access data but who have little knowledge of the SQL language.
The Query Modeler button is on the standard toolbar (the top menu bar, see Figure 3.32). You can also access it via Database → Report → Query Builder, and the button also appears on the ER Diagrammer panel.
FIGURE 3.32 Query Builder button
The object palette appears on the right (if it doesn’t automatically appear, click View → Object Palette). The various items that ...