Toad for Oracle on Mac - Knowledge Base

Installation Guide >

Getting Started Guide > Call Stack Window

The Call Stack window displays the chain of functions and procedures as they are called, in the order they are called, with the most recent function or procedure listed on the top. ... At the end of each procedure name is the current line number in that procedure.

Getting Started Guide > Use Query Templates

select * ... from dba_tables ... where owner = <ObjectOwner> ... and table_name in <ObjectList>

Getting Started Guide > Sort and Group Data

If the query does not contain an ORDER BY command, you can sort the grid manually. ... To sort by column ... Click a grid column header.

Getting Started Guide > Compare Data Duplicates

Use this dialog box to view record duplicates based on user input. ... To view record duplicates ... A list of columns is displayed below. ... Now, you can do any of the following: ... Do not select any columns in the list.

Getting Started Guide > Preview Query Results

Use the Describe (Parse) Select Query function to see what columns would be returned if the query were executed. ... This is useful for tuning a LONG query before it is executed.

Getting Started Guide > View Icon Legend

Many of the panes within the Schema Browser have icons to identify the objects. ... Toad includes an Icon Legend that you can use to easily decipher these images.