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.

Table of Contents

Chapter 1. Getting Started
Chapter 2. Fast Track
Chapter 3. Working with SQL
Chapter 4. Schema Browser
Chapter 5. Working with Data
Chapter 6. Working with PL/SQL
Chapter 7. Miscellaneous Tools
Chapter 8. Getting Started with Toad Automation
Chapter 9. Database Administration
Chapter 10. Toad as a SQL Tuning Tool