9780321649102

Toad Handbook

by ;
  • ISBN13:

    9780321649102

  • ISBN10:

    0321649109

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

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $12.50
  • Buy Used
    $37.49
    Add to Cart Free Shipping

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

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

Acknowledmentsp. xiii
About the Authors xv
Introductionp. 1
Who should Read This Bookp. 1
Why This Books Is Uniquep. 2
How This Book Is Organizedp. 2
p. 5
Windows Platform Supportp. 6
Database Connectivityp. 7
Database Client Versionsp. 10
Which Version of Toad to Usep. 10
Running the Toad Installerp. 12
Copying Toad Settingsp. 13
Toad Adheres to Oracle Securityp. 13
Activating Toad's Read-Only Modep. 15
Advanced Toad's Security Optionsp. 15
Customizing Toad to User Tastep. 16
Summaryp. 17
Database and Schema Browsersp. 19
Auto-Start a Browserp. 20
Database Browserp. 21
Schema Browserp. 27
Schema Browser Optionsp. 42
Summaryp. 44
SQL Editorp. 45
Basic Concepts of the SQL Editorp. 45
Predefined Shortcutsp. 59
User-Defined Shortcutsp. 62
Using Bind Variablesp. 63
Table and Column Name Select Listsp. 64
Toad Table Aliases Substitutionsp. 66
Auto-Replacement Substitutionsp. 67
SQL Templatesp. 68
Code Snippetsp. 70
Executing SQL Statementsp. 71
Executing SQL Scriptsp. 72
Editing Result-Set Datap. 73
Saving Result-Set Datap. 75
Printing Result-Set Datap. 76
Examining Explain Plansp. 79
Examining Basic Performance Informationp. 82
Other Result Output Tabsp. 84
SQL Plus Compatibilityp. 84
SQL-Creating-SQLp. 87
Summaryp. 88
Toad PL/SQL Editorp. 89
Basic Concepts of the PL/SQL Editorp. 89
Formating PL/SQL Codep. 96
Predefined Shortcutsp. 98
Using Aliases, Pick Lists, Shortcuts, Snippets, and Auto-Replacement Substitutionsp. 101
PL/SQL Object Templatesp. 102
Compiling PL/SQL Codep. 105
Executing PL/SQL Codep. 105
Saving PL/SQL Code to Filesp. 107
Debugging Setup, Requirements, and Parametersp. 108
Basic Debugging PL/SQL Codep. 109
Advanced Debugging PL/SQL Codep. 115
Profiling PL/SQL Codep. 120
Setting up Source Code Controlp. 123
Using Sources Code Controlp. 123
Summaryp. 123
Database Reportingp. 125
Toad Report Managerp. 125
Building Reports Using Fast Reportsp. 131
Adding Reports to the Toad Report Managerp. 141
Using the HTML Schema Document Generatorp. 144
Summaryp. 148
Tuning Tools in Toadp. 149
Oracle Tuning Using Toadp. 149
SQL Explain Plans\Auto Tracep. 150
Oracle Trace Facilityp. 155
StatsPack Reportingp. 165
Automated Workload Repository Reportingp. 168
Summaryp. 171
Database Health Checkp. 174
Creating New Databasesp. 176
Tablespaces and Data Filesp. 178
Start-ups and Shut-downsp. 181
Oracle and NLS Parametersp. 183
Generating Database Scriptsp. 186
Generating Schema Scriptsp. 188
Comparing Database Differencesp. 190
Rebuilding multiple Objectsp. 195
Top Session Finderp. 197
SGA Trace/Optimizationp. 198
Session Browserp. 200
Summaryp. 203
Exporting Table Datap. 205
Saving Grid Contentsp. 205
Flat File Exportp. 208
Creating Insertsp. 209
Schema Browser Scriptp. 210
Oracle Exportp. 211
Data Pump Exportp. 214
Data Subset Wizardp. 218
Import Table Datap. 220
Summaryp. 222
Other Useful toolsp. 223
Master-Detail Browserp. 223
ER Diagramp. 227
Code Road Mapp. 229
Query Builderp. 232
External Toolsp. 238
Compare Filesp. 240
TNS Editorp. 241
Scripts Managerp. 243
Summaryp. 245
Toad App Designerp. 247
Toad Command Linep. 247
Toad App Designerp. 251
Summaryp. 260
Indexp. 261
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review