Using the Main TOAD Interface

When TOAD starts up, it puts you in the SQL Editor window. The SQL Editor is the heart of TOAD, and it lets you type, edit, recall, execute, and tune. The window contains an editor to compose SQL statements or scripts and a results grid to display the results from SELECT SQL statements. A horizontal splitter between the editor and the results grid lets you size each panel accordingly. The Show Tables window (see Figure 16.2) button invokes the Table Names Select window, which lets you select tables from a dropdown list.


Many windows in TOAD contain an additional menu of useful options, accessed by a right mouse click. In the Editor the menu includes the ability to comment/uncomment highlighted statements as well ...

Get Oracle9i™ Development by Example 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.