Toad Handbook

by Scalzo, Bert; Hotka, Dan

• ISBN13: 9780321649102
• ISBN10: 0321649109
• Edition: 2nd
• Format: Paperback
• Copyright: 2009-09-14
• Publisher: Addison-Wesley Professional

Summary

TOAD reg; Handbook, Second Edition,is the definitive, completely up-to-date guide to the newest version of TOAD, the worldrs"s premier third-party Oracle utility. Packed with step-by-step recipes, screen snapshots, and hands-on exercises, this book brings together everything developers and DBAs need to maximize their productivity with TOAD in both administrative and development tasks. TOAD product architect Bert Scalzo and leading TOAD trainer Dan Hotka thoroughly cover every area of TOADrs"s functionality, offering practical, proven solutions that can be applied immediately to leverage TOADrs"s dramatically improved feature set. Comprehensive coverage includes TOAD setup and configuration Browsing databases and schemas Editing SQL and PL/SQL within TOAD Creating new databases Checking database health Performing common DBA tasks Reporting via standard and custom reports Optimizing database performance Throughout the text, the authors offer practical insights into each of TOADrs"s most useful tools, from App Designer to Doc Generator, ER Diagrammer to Code Road Map. This book is the only current, comprehensive, and affordable guide to the latest version of TOADa must-have for any TOAD user.

Author Biography

Bert Scaizo, currently Toad product at Quest Software, has worked with Oracle databases for well over two decades, including stints at both Oracle Education and Oracle Consulting. An accomplished speaker and presenter at Oracle conferences and user groups, he is author of many books, including Toad Pocket Reference for Oracle, Second Edition (O'Reilly Media, Inc., 2005) and Oracle DBA Guide to data warehousing and Star Schemes (Prentice Hall, 2003). Dan Hotka, an internationally recognized Oracle expert, has twenty-six years of experience with Oracle products. He regularly teaches courses on Toad and works closely with Quest Software. He was authored or coauthored eleven books and speaks regularly at Oracle conferences and user groups around the world. He can be found on the Web at Dan Hotka.com.

Table of Contents

Acknowledments	p. xiii
About the Authors xv
Introduction	p. 1
Who should Read This Book	p. 1
Why This Books Is Unique	p. 2
How This Book Is Organized	p. 2
	p. 5
Windows Platform Support	p. 6
Database Connectivity	p. 7
Database Client Versions	p. 10
Which Version of Toad to Use	p. 10
Running the Toad Installer	p. 12
Copying Toad Settings	p. 13
Toad Adheres to Oracle Security	p. 13
Activating Toad's Read-Only Mode	p. 15
Advanced Toad's Security Options	p. 15
Customizing Toad to User Taste	p. 16
Summary	p. 17
Database and Schema Browsers	p. 19
Auto-Start a Browser	p. 20
Database Browser	p. 21
Schema Browser	p. 27
Schema Browser Options	p. 42
Summary	p. 44
SQL Editor	p. 45
Basic Concepts of the SQL Editor	p. 45
Predefined Shortcuts	p. 59
User-Defined Shortcuts	p. 62
Using Bind Variables	p. 63
Table and Column Name Select Lists	p. 64
Toad Table Aliases Substitutions	p. 66
Auto-Replacement Substitutions	p. 67
SQL Templates	p. 68
Code Snippets	p. 70
Executing SQL Statements	p. 71
Executing SQL Scripts	p. 72
Editing Result-Set Data	p. 73
Saving Result-Set Data	p. 75
Printing Result-Set Data	p. 76
Examining Explain Plans	p. 79
Examining Basic Performance Information	p. 82
Other Result Output Tabs	p. 84
SQL Plus Compatibility	p. 84
SQL-Creating-SQL	p. 87
Summary	p. 88
Toad PL/SQL Editor	p. 89
Basic Concepts of the PL/SQL Editor	p. 89
Formating PL/SQL Code	p. 96
Predefined Shortcuts	p. 98
Using Aliases, Pick Lists, Shortcuts, Snippets, and Auto-Replacement Substitutions	p. 101
PL/SQL Object Templates	p. 102
Compiling PL/SQL Code	p. 105
Executing PL/SQL Code	p. 105
Saving PL/SQL Code to Files	p. 107
Debugging Setup, Requirements, and Parameters	p. 108
Basic Debugging PL/SQL Code	p. 109
Advanced Debugging PL/SQL Code	p. 115
Profiling PL/SQL Code	p. 120
Setting up Source Code Control	p. 123
Using Sources Code Control	p. 123
Summary	p. 123
Database Reporting	p. 125
Toad Report Manager	p. 125
Building Reports Using Fast Reports	p. 131
Adding Reports to the Toad Report Manager	p. 141
Using the HTML Schema Document Generator	p. 144
Summary	p. 148
Tuning Tools in Toad	p. 149
Oracle Tuning Using Toad	p. 149
SQL Explain Plans\Auto Trace	p. 150
Oracle Trace Facility	p. 155
StatsPack Reporting	p. 165
Automated Workload Repository Reporting	p. 168
Summary	p. 171
Database Health Check	p. 174
Creating New Databases	p. 176
Tablespaces and Data Files	p. 178
Start-ups and Shut-downs	p. 181
Oracle and NLS Parameters	p. 183
Generating Database Scripts	p. 186
Generating Schema Scripts	p. 188
Comparing Database Differences	p. 190
Rebuilding multiple Objects	p. 195
Top Session Finder	p. 197
SGA Trace/Optimization	p. 198
Session Browser	p. 200
Summary	p. 203
Exporting Table Data	p. 205
Saving Grid Contents	p. 205
Flat File Export	p. 208
Creating Inserts	p. 209
Schema Browser Script	p. 210
Oracle Export	p. 211
Data Pump Export	p. 214
Data Subset Wizard	p. 218
Import Table Data	p. 220
Summary	p. 222
Other Useful tools	p. 223
Master-Detail Browser	p. 223
ER Diagram	p. 227
Code Road Map	p. 229
Query Builder	p. 232
External Tools	p. 238
Compare Files	p. 240
TNS Editor	p. 241
Scripts Manager	p. 243
Summary	p. 245
Toad App Designer	p. 247
Toad Command Line	p. 247
Toad App Designer	p. 251
Summary	p. 260
Index	p. 261
Table of Contents provided by Ingram. All Rights Reserved.