The Script Output tab shows character-mode output when the Run as Script button is clicked for execution. The REF CURSOR Results tab is also associated with PL/SQL execution. This information is useful for either rerunning that exact same SQL or when doing performance tuning (to easily compare one SQL execution with another). The Query Viewer tab shows SQL and PL/SQL that was executed in the SQL window and some interesting statistics such as how long it took to execute. The Profiler tab is associated with the PL/SQL Profiler discussed in Chapter 6. The Navigator tab displays the Navigator panel to the left of the Editor window. The Messages tab shows any output from the executed SQL, including error messages (its real value). To populate this tab, click the Explain Plan button. The Explain Plan tab (discussed later this chapter and again in Chapter 10, “Toad as a SQL Tuning Tool”) shows the SQL execution plan it also has many display options. The DBMS Output tab shows any DBMS_OUTPUT.Put_Line output from a PL/SQL routine. Data grids appear throughout Toad, and the options that are available for this data grid are also available for any data grid. The Data Grid tab is associated with any SQL select statement execution. The Breakpoints, Call Stack, and Watches tabs are all associated with the PL/SQL Debugger (covered in Chapter 6, “Working with PL/SQL”).

You can also right-click the editor panel and select Desktop from that pop-up menu to get the same list. Right-click the tab line to see all the tabs available.

You can easily display or hide these tabs.

Toad for oracle error codes