SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK TOAD POCKET REFERENCE FOR ORACLE, 2ND EDITION
SUMMARY
-
Items Found: 86
- 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
- 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
- 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
- Additional Toad Modules 112
- Toad for Oracle 113
- Toad for Oracle Professional Edition 113
- Toad for Oracle Xpert Edition 113
- Toad for Oracle Suite 113
- Index 115
