TOAD Handbook
2nd Edition
Published on 24. September 2009
Book
Paperback/Softback
312 pages
978-0-321-64910-2 (ISBN)
Description
TOAD (R) Handbook, Second Edition, is the definitive, completely up-to-date guide to the newest version of TOAD, the world'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 TOAD's functionality, offering practical, proven solutions that can be applied immediately to leverage TOAD'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 TOAD'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 TOAD-a must-have for any TOAD user.
TOAD product architect Bert Scalzo and leading TOAD trainer Dan Hotka thoroughly cover every area of TOAD's functionality, offering practical, proven solutions that can be applied immediately to leverage TOAD'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 TOAD'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 TOAD-a must-have for any TOAD user.
More details
Edition
2nd edition
Language
English
Place of publication
New Jersey
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Dimensions
Height: 228 mm
Width: 179 mm
Thickness: 16 mm
Weight
484 gr
ISBN-13
978-0-321-64910-2 (9780321649102)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Previous edition
Bert Scalzo | Dan Hotka
TOAD Handbook
Book
03/2003
Sams Publishing
€27.22
Article exhausted; check for reprint
Persons
Bert Scalzo, currently TOAD product architect 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 Schemas (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 has 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 DanHotka.com.
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 has 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 DanHotka.com.
Content
Acknowledgments xiii
About the Authors xv
Introduction 1
Who Should Read This Book 1
Why This Book Is Unique 2
How This Book Is Organized 2
Chapter 1: TOAD Setup and Configuration 5
Windows Platform Support 6
Database Connectivity 7
Database Client Versions 10
Which Version of TOAD to Use 10
Running the TOAD Installer 12
Copying TOAD Settings 13
TOAD Adheres to Oracle Security 13
Activating TOAD's Read-Only Mode 15
Advanced TOAD Security Options 15
Customizing TOAD to User Taste 16
Summary 17
Chapter 2: Database and Schema Browsers 19
Auto-Start a Browser 20
Database Browser 21
Schema Browser 27
Schema Browser Options 42
Summary 44
Chapter 3: SQL Editor 45
Basic Concepts of the SQL Editor 45
Predefined Shortcuts 59
User-Defined Shortcuts 62
Using Bind Variables 63
Table and Column Name Select Lists 64
TOAD Table Aliases Substitutions 66
Auto-Replacement Substitutions 67
SQL Templates 68
Code Snippets 70
Executing SQL Statements 71
Executing SQL Scripts 72
Editing Result-Set Data 73
Saving Result-Set Data 75
Printing Result-Set Data 76
Examining Explain Plans 79
Examining Basic Performance Information 82
Other Result Output Tabs 84
SQL*Plus Compatibility 84
SQL-Creating-SQL 87
Summary 88
Chapter 4: TOAD PL/SQL Editor 89
Basic Concepts of the PL/SQL Editor 89
Formatting PL/SQL Code 96
Predefined Shortcuts 98
Using Aliases, Pick Lists, Shortcuts, Snippets, and Auto-
Replacement Substitutions 101
PL/SQL Object Templates 102
Compiling PL/SQL Code 105
Executing PL/SQL Code 105
Saving PL/SQL Code to Files 107
Debugging Setup, Requirements, and Parameters 108
Basic Debugging PL/SQL Code 109
Debugging Breakpoint Options 115
Advanced Debugging PL/SQL Code 117
Profiling PL/SQL Code 120
Setting Up Source Code Control 123
Using Source Code Control 123
Summary 123
Chapter 5: Database Reporting 125
TOAD Report Manager 125
Building Reports Using Fast Reports 131
Adding Reports to the TOAD Report Manager 141
Using the HTML Schema Document Generator 144
Summary 148
Chapter 6: Tuning Tools in TOAD 149
Oracle Tuning Using TOAD 149
SQL Explain Plans/Auto Trace 150
Oracle Trace Facility 155
StatsPack Reporting 165
Automated Workload Repository Reporting 168
Summary 171
Chapter 7: Database Management 173
Database Health Check 174
Creating New Databases 176
Tablespaces and Data Files 178
Start-ups and Shut-downs 181
Oracle and NLS Parameters 183
Generating Database Scripts 186
Generating Schema Scripts 188
Comparing Database Differences 190
Rebuilding Multiple Objects 195
Top Session Finder 197
SGA Trace/Optimization 198
Session Browser 200
Summary 203
Chapter 8: Exporting Table Data 205
Saving Grid Contents 205
Flat File Export 208
Creating Inserts 209
Schema Browser Script 210
Oracle Export 211
Data Pump Export 214
Data Subset Wizard 218
Import Table Data 220
Summary 222
Chapter 9: Other Useful Tools 223
Master-Detail Browser 223
ER Diagram 227
Code Road Map 229
Query Builder 232
External Tools 238
Compare Files 240
TNS Editor 241
Script Manager 243
Summary 245
Chapter 10: TOAD App Designer 247
TOAD Command Line 247
TOAD App Designer 251
Summary 260
Index 261
About the Authors xv
Introduction 1
Who Should Read This Book 1
Why This Book Is Unique 2
How This Book Is Organized 2
Chapter 1: TOAD Setup and Configuration 5
Windows Platform Support 6
Database Connectivity 7
Database Client Versions 10
Which Version of TOAD to Use 10
Running the TOAD Installer 12
Copying TOAD Settings 13
TOAD Adheres to Oracle Security 13
Activating TOAD's Read-Only Mode 15
Advanced TOAD Security Options 15
Customizing TOAD to User Taste 16
Summary 17
Chapter 2: Database and Schema Browsers 19
Auto-Start a Browser 20
Database Browser 21
Schema Browser 27
Schema Browser Options 42
Summary 44
Chapter 3: SQL Editor 45
Basic Concepts of the SQL Editor 45
Predefined Shortcuts 59
User-Defined Shortcuts 62
Using Bind Variables 63
Table and Column Name Select Lists 64
TOAD Table Aliases Substitutions 66
Auto-Replacement Substitutions 67
SQL Templates 68
Code Snippets 70
Executing SQL Statements 71
Executing SQL Scripts 72
Editing Result-Set Data 73
Saving Result-Set Data 75
Printing Result-Set Data 76
Examining Explain Plans 79
Examining Basic Performance Information 82
Other Result Output Tabs 84
SQL*Plus Compatibility 84
SQL-Creating-SQL 87
Summary 88
Chapter 4: TOAD PL/SQL Editor 89
Basic Concepts of the PL/SQL Editor 89
Formatting PL/SQL Code 96
Predefined Shortcuts 98
Using Aliases, Pick Lists, Shortcuts, Snippets, and Auto-
Replacement Substitutions 101
PL/SQL Object Templates 102
Compiling PL/SQL Code 105
Executing PL/SQL Code 105
Saving PL/SQL Code to Files 107
Debugging Setup, Requirements, and Parameters 108
Basic Debugging PL/SQL Code 109
Debugging Breakpoint Options 115
Advanced Debugging PL/SQL Code 117
Profiling PL/SQL Code 120
Setting Up Source Code Control 123
Using Source Code Control 123
Summary 123
Chapter 5: Database Reporting 125
TOAD Report Manager 125
Building Reports Using Fast Reports 131
Adding Reports to the TOAD Report Manager 141
Using the HTML Schema Document Generator 144
Summary 148
Chapter 6: Tuning Tools in TOAD 149
Oracle Tuning Using TOAD 149
SQL Explain Plans/Auto Trace 150
Oracle Trace Facility 155
StatsPack Reporting 165
Automated Workload Repository Reporting 168
Summary 171
Chapter 7: Database Management 173
Database Health Check 174
Creating New Databases 176
Tablespaces and Data Files 178
Start-ups and Shut-downs 181
Oracle and NLS Parameters 183
Generating Database Scripts 186
Generating Schema Scripts 188
Comparing Database Differences 190
Rebuilding Multiple Objects 195
Top Session Finder 197
SGA Trace/Optimization 198
Session Browser 200
Summary 203
Chapter 8: Exporting Table Data 205
Saving Grid Contents 205
Flat File Export 208
Creating Inserts 209
Schema Browser Script 210
Oracle Export 211
Data Pump Export 214
Data Subset Wizard 218
Import Table Data 220
Summary 222
Chapter 9: Other Useful Tools 223
Master-Detail Browser 223
ER Diagram 227
Code Road Map 229
Query Builder 232
External Tools 238
Compare Files 240
TNS Editor 241
Script Manager 243
Summary 245
Chapter 10: TOAD App Designer 247
TOAD Command Line 247
TOAD App Designer 251
Summary 260
Index 261