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.

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.

TOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD. Starting with installation and configuration, the book covers the TOAD SQL editors in depth, including dozens of helpful, undocumented features. Later chapters discuss reporting and exporting data and using several add-on tools designed to enhance TOAD development. Along the way, the authors provide critical insights into the workings of TOAD and how developers can use it to make the most of their applications. Includes a foreword by Jim McDaniel, the inventor of TOAD.

Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format.