Modeling Complex SQL Visually

Not everyone is comfortable with writing SQL, especially complex joins with group operations, HAVING clauses, and sorts. What many people want is a visual query builder that enables them to model what they want and that can then generate the SQL that’s required. For this need, TOAD offers the SQL Modeler shown in Figure 9.8 and located on the main menu at Database, SQL Modeler. And though this screen may look very simple, it’s one of the most feature-rich and powerful screens within TOAD. There are very few SQL coding techniques that cannot be successfully modeled here and then generated.

Figure 9.8. TOAD SQL Modeler—basic operation.

When you first enter this screen, both the top left and bottom portions of the ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.