Toad Insights

Toad provides easy creation of SQL. The previously mentioned Describe Objects panel enables you to drag and drop columns out of any table object into the SQL Editor. You can also enter the table name (or table alias) with a single period, the table name, another period, and partial leading column spelling, and Toad will pop up a box containing your table object columns and column attributes. Figure 3.20 shows a table with just a single period.

Image

FIGURE 3.20 Toad Insights pop-up panel

You can double-click a column in this pop-up window, or multiple select using the mouse and either the Shift (list of items) or Ctrl buttons (specific ...

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.