Query Builder

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.

Image

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 ...

Get Toad for Oracle Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.