Toad for Oracle Unleashed

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 Dan@DanHotka.com DanHotka.Blogspot.com

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