Overview

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

See more details below
TOAD Handbook

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook - 2)
$22.99
BN.com price
(Save 42%)$39.99 List Price

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780321649164
  • Publisher: Pearson Education
  • Publication date: 9/28/2009
  • Series: Developer's Library
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition description: 2
  • Edition number: 2
  • Pages: 312
  • Sales rank: 868,437
  • File size: 12 MB
  • Note: This product may take a few minutes to download.

Meet the Author

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.

Read More Show Less

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

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)