Toad Pocket Reference for Oracle, 2nd Edition

iii

Contents

Introduction 1

Contributors 2

Caveats 3

For Help with Toad 4

Conventions 5

Toad Basics 5

Installing and Configuring Toad 6

Expanding Toad’s Functionality 6

Configuring External Tools 7

Toad Startup and Other Options 7

Toad Properties Files 9

Toad Menu Toolbar 10

Toad Toolbar Display 12

SQL Editor 12

Display 13

Toolbars and Menus 13

Shortcut Keys 18

Supporting Other Parsers/Languages 21

Working with Files in the SQL Editor 22

Executing Statements 23

Using Extended Features 26

iv

|

Contents

Data Grid 33

Manipulating the Display, not the Query 34

Navigating the Grid 36

Editing Data from the Data Grid 37

Saving/Sending Data in Various Formats 39

Working with Data 42

SQL Optimization 44

Explain Plans 44

SQL Optimization Facilities 46

Additional Tuning Methods 50

Schema Browser 50

Configuring the Schema Browser 51

Objects Panel 54

Details Panel 57

Schema Browser Tips and Tricks 59

Procedure Editor 59

Procedure Editor Options 60

Configuring the Procedure Editor 61

Procedure Editor Display 61

Procedure Editor Keys 62

Procedure Editor Menus and Toolbars 63

Populating the Procedure Editor 64

Procedure Editor Shortcut Keys 66

Using the Procedure Editor 66

Debugger 70

Setting Debugger Options 70

Debugger Menus and Toolbar 71

Output Panel 73

Setting Parameters 76

Just-in-Time Debugging ...