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 76
Contents
|
v
Executing a Stored Program from the Debugger 77
Executing a Stored Program Without Debugging 77
After Debugging 78
Code Profiling 78
Using CodeXpert 78
Database Administration 82
Using the DBA Module 83
Using the Database Browser 85
Modifying Oracle Parameters 86
Managing Sessions 88
Creating and Altering Objects 90
Managing Tablespaces 90
Checking Extents 94
Using Oracle’s Import/Export Tools 94
Using Other Toad Import/Export Utilities 95
Comparing Schemas and Databases 97
Performing SGA Trace Optimization 98
Using the HTML Schema Doc Generator 100
User Administration 100
Managing Users 102
Managing Roles 104
Managing Resource Groups and Resource Plans 104
Managing Policies and Policy Groups 105
Auditing 105
Project Manager 107
Creating and Using Projects 109
Customizing Project Manager’s Behavior 110
Saving and Sharing Project Files 111
Project Manager Tips and Tricks 111
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.