Table and Column Name Select Lists

Table and Column Name Select Lists

TOAD makes it easy to find and work with tables and columns . Figure 4.12 illustrates using the Show Table Select Window button (mouse cursor is pointing to this button). This brings up the Table Name Select window, with a list of available tables for this particular user. If the user has privileges to other schemas, the drop-down list in this window can be changed to the schema owner and those objects will then appear in the select list. Double-clicking on the selected object adds the selected table to the Procedure Editor at the current cursor location.

Figure 4.12. Table Name Select list.

Similarly, columns can be added to the Procedure Editor by using the Show Column Select Window button. Figure 4.13 illustrates using this window to add the columns INV_MAKE and INV_TYPE to the SQL in the Procedure Editor. Notice the cursor is pointing to the Show Column Select Window button.

Figure 4.13. Automatic column select lists.

TOAD will automatically give a column select list if you type or select a valid schema table name followed by a '.'. Wait a second and the column select list will appear as illustrated in Figure 4.14!

Figure 4.14. Column Name Select list.