Product Cover Image

TOAD Handbook,, 2nd Edition

By Bert Scalzo, Dan Hotka

Published by Addison-Wesley Professional

Published Date: Sep 14, 2009

Description

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

Purchase Info

ISBN-10: 0-13-265218-8

ISBN-13: 978-0-13-265218-6

Format: eBook (Watermarked)?

This eBook includes the following formats, accessible from your Account page after purchase:

ePubEPUBThe open industry format known for its reflowable content and usability on supported mobile devices.

MOBIMOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

Adobe ReaderPDFThe popular standard, used most often with the free Adobe® Reader® software.

This eBook requires no passwords or activation to read. We customize your eBook by discretely watermarking it with your name, making it uniquely yours.

Includes EPUB, MOBI, and PDF

$39.99 $31.99

Add to Cart