TOAD Handbook
Home > Computing and Information Technology > Databases > Database software > TOAD Handbook
TOAD Handbook

TOAD Handbook

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

TOAD® 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.

Table of Contents:
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


Best Sellers


Product Details
  • ISBN-13: 9780321649102
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison-Wesley Educational Publishers Inc
  • Height: 228 mm
  • No of Pages: 312
  • Weight: 484 gr
  • ISBN-10: 0321649109
  • Publisher Date: 24 Sep 2009
  • Binding: Paperback
  • Language: English
  • Spine Width: 16 mm
  • Width: 179 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
TOAD Handbook
Pearson Education (US) -
TOAD Handbook
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

TOAD Handbook

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!