Toad for Oracle Unleashed

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.

Auteur

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

Contenu

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