Toad Pocket Reference for Oracle, 2nd Edition

Procedure Editor

|

59

Schema Browser Tips and Tricks

Here are some suggestions for using the Schema Browser to

your best advantage:

• Double-click an object on the LHS to alter it. Right-click

to do just about anything else with it.

• Drag-and-drop an object into a Toad editor for faster

querying.

• Use Toad Security to disable the Truncate and Drop buttons.

• If the object is present in a label on the RHS of the

Schema Browser, you can describe the object or jump to

the object:

• To describe the object, click on the object label.

• To jump to the object, hold down CTRL and click.

• If the object is present in an information grid on the RHS

of the Schema Browser, you can describe the object or

jump to the object:

• To describe the object, press F4 on the object label.

• To jump to the object, hold down SHIFT and press F4.

• To make more room for information, disable the Show

LHS Images function from the browser-style RHS toolbar.

• Use the LHS QuickFilter box to filter the object list with-

out having to requery the database.

• Right-click on the LHS header to enable the Schema |

Tablespace | Last Analyzed columns for your objects.

• Enable the LHS filtering option Search in All Schemas to

show all database objects in a single list.

Procedure Editor

Toad’s Procedure Editor is designed to make editing, compil-

ing, and executing stored programs as easy as possible. The

Procedure Editor and the SQL Editor have ...