Toad for Oracle Unleashed

by Bert Scalzo, Dan Hotka

Overview

Bert Scalzo and Dan Hotka have written the definitive, up-to-date guide to Version 12.x, Dell’s powerful new release of Toad for Oracle. Packed with step-by-step recipes, detailed screen shots, and hands-on exercises, Toad for Oracle Unleashed shows both developers and DBAs how to maximize their productivity.

Drawing on their unsurpassed experience running Toad in production Oracle environments, Scalzo and Hotka thoroughly cover every area of Toad’s functionality. You’ll find practical insights into each of Toad’s most useful tools, from App Designer to Doc Generator, ER Diagrammer to Code Road Map. The authors offer proven solutions you can apply immediately to solve a wide variety of problems, from maintaining code integrity to automating performance and scalability testing.

 

Learn how to…

• Install and launch Toad, connect to a database, and explore Toad’s new features
• Customize Toad to optimize productivity in your environment
• Use the Editor Window to execute SQL and PL/SQL, and view, save, or convert data
• Browse your schema, and create and edit objects
• Quickly generate useful reports with FastReport and Report Manager
• Clarify your database’s tables and data with the powerful Entity Relationship Diagrammer (ERD) and HTML documentation generator
• Work more efficiently with PL/SQL using code templates, snippets, and shortcuts
• Automate actions and applications with Automation Designer
• Perform key DBA tasks including database health checks, tablespace management, database and schema comparisons, and object rebuilding
• Identify and optimize poorlyperforming SQL and applications

ON THE WEB:
Download all examples and source code presented in this book from informit.com/title/9780134131856 as it becomes available.

Product Details

ISBN-13:	9780134131894
Publisher:	Pearson Education
Publication date:	06/29/2015
Series:	Unleashed
Sold by:	Barnes & Noble
Format:	eBook
Pages:	288
File size:	31 MB
Note:	This product may take a few minutes to download.
Age Range:	18 Years

About the Author

Bert Scalzo is a Database Expert for HGST (a Western Digital company) and was formerly at Dell Software as a member of the Toad dev team for 15 years. He has worked with Oracle databases for more than two decades. Mr. Scalzo’s work history includes time at both Oracle Education and Oracle Consulting. He holds several Oracle Masters certifications and has an extensive academic background—including a BS, MS, and PhD in Computer Science, an MBA, plus insurance industry designations. Mr. Scalzo is also an Oracle ACE.
Mr. Scalzo is an accomplished speaker and has presented at numerous Oracle conferences and user groups, including OOW, ODTUG, IOUG, OAUG, RMOUG, and many others.
He has written several books and numerous articles, papers, and blogs for the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ, and Toad World.
http://bertscalzo.com/

Dan Hotka is a Training Specialist and an Oracle ACE Director who has more than 37 years in the computer industry, and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.
Dan Hotka, Author/Instructor/Oracle ACE Director
www.DanHotka.com
[e-mail]
DanHotka.Blogspot.com

Table of Contents

Introduction     xi

Who Should Read This Book     xi
Why This Book Is Unique     xii
How This Book Is Organized     xii

1 Getting Started     1

Introduction to Toad     1
     Toad Release History     2
     Toad Editions and Suites     3
     Prerequisites and Installation     5
Running Toad the First Time     8
     Oracle Client Software     9
     Database Connections     10
     Introduction to Main Screens     16
     Basic Toad Customizations     18
Common Newbie Questions     21
     Can Toad Do That?     21
     Toad versus Database Security     22
     Sharing Toad Options Settings     22
     Help—Toad Running Slowly     22
Summary     23

2 Fast Track     25

Organizing Connections     25
Toolbars and Menus     30
Keyboard Shortcut Keys     33
Startup Windows/Screens     34
Startup Files, Scripts, and Actions     36
Advanced Toad Customizations     37
Sharing Toad Settings     40
Summary     41

3 Working with SQL     43

Editor Window     43
SQL Editor Output Area     48
Object Describe     51
Toad Insights     57
Code Snippets     58
SQL Recall     60
Auto Replace     63
Query Builder     64
Summary     68

4 Schema Browser     69

Configuring the Schema Browser     69
Creating and Editing Objects     76
Printing Data Using FastReport     79
Using the Reports Manager     85
Summary     91

5 Working with Data     93

Reviewing Data Grid Options     93
     Filter/Sort the Table Data     97
     View/Edit Query     99
     Show/Hide Columns     100
     Show Detail Dataset     100
     Calculate Selected Cells     101
     Export Dataset     102
     Refresh Dataset     103
     Cancel Query Execution or Fetch     104
     Add/Delete Rows     104
     Row Set Navigation Buttons     105
     Edit Row Set Control Buttons     105
     Commit/Rollback     105
     Bookmark Navigation     105
     Single Record Viewer     105
Save Data in Various Formats     106
Master Detail Browser     111
ER Diagrammer     113
HTML Documentation Generator     115
Summary     119

6 Working with PL/SQL     121

Using the Editor     121
Using Code Templates     127
Project Manager     132
Using Code Snippets     133
Code Shortcuts     135
Code Analysis     139
Using the Debugger     142
     Basic Debugging     142
     Advanced Debugging Techniques     148
Using the PL/SQL Profiler     153
Summary     156

7 Miscellaneous Tools     157

Code Road Map     157
External Tools     160
Compare Files     163
TNS Editor     164
Script Manager     165
UNIX Monitor     167
Summary     169

8 Getting Started with Toad Automation     171

Command Line (Legacy)     172
Automation Designer (Future)     180
Summary     190

9 Database Administration     191

Health Check     192
Session Browser     194
Database Browser     197
Simple Export     202
Data Pump Export     205
Tablespace Management     210
Generate Database Script     212
Generate Schema Script     214
Compare Databases     216
Compare Schema     218
Analyze All Objects     220
Rebuild Multiple Objects     223
Summary     224

10 Toad as a SQL Tuning Tool     227

Toad and Explain Plans     227
SQL Statistics     231
Toad and SQL Trace     233
     Toad and TKPROF     238
     Toad and Trace File Browser     241
Statspack Interface     243
AWR Browser     245
Toad and the PL/SQL Profiler     246
Toad and the SQL Optimizer     248
Summary     249

Index     251