TOAD Handbook (Developer's Library Series)
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...
Search in google:
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 performanceThroughout 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.
Acknowledments xiiiAbout the Authors\|xvIntroduction 1Who should Read This Book 1Why This Books Is Unique 2How This Book Is Organized 21\|Toad Setup and Configuration 5Windows Platform Support 6Database Connectivity 7Database Client Versions 10Which Version of Toad to Use 10Running the Toad Installer 12Copying Toad Settings 13Toad Adheres to Oracle Security 13Activating Toad's Read-Only Mode 15Advanced Toad's Security Options 15Customizing Toad to User Taste 16Summary 172 Database and Schema Browsers 19Auto-Start a Browser 20Database Browser 21Schema Browser 27Schema Browser Options 42Summary 443 SQL Editor 45Basic Concepts of the SQL Editor 45Predefined Shortcuts 59User-Defined Shortcuts 62Using Bind Variables 63Table and Column Name Select Lists 64Toad Table Aliases Substitutions 66Auto-Replacement Substitutions 67SQL Templates 68Code Snippets 70Executing SQL Statements 71Executing SQL Scripts 72Editing Result-Set Data 73Saving Result-Set Data 75Printing Result-Set Data 76Examining Explain Plans 79Examining Basic Performance Information 82Other Result Output Tabs 84SQL Plus Compatibility 84SQL-Creating-SQL 87Summary 884 Toad PL/SQL Editor 89Basic Concepts of the PL/SQL Editor 89Formating PL/SQL Code 96Predefined Shortcuts 98Using Aliases, Pick Lists, Shortcuts, Snippets, and Auto-Replacement Substitutions 101PL/SQL Object Templates 102Compiling PL/SQL Code 105Executing PL/SQL Code 105Saving PL/SQL Code to Files 107Debugging Setup, Requirements, and Parameters 108Basic Debugging PL/SQL Code 109Advanced Debugging PL/SQL Code115Profiling PL/SQL Code 120Setting up Source Code Control 123Using Sources Code Control 123Summary 1235 Database Reporting 125Toad Report Manager 125Building Reports Using Fast Reports 131Adding Reports to the Toad Report Manager 141Using the HTML Schema Document Generator 144Summary 1486 Tuning Tools in Toad 149Oracle Tuning Using Toad 149SQL Explain Plans\\Auto Trace 150Oracle Trace Facility 155StatsPack Reporting 165Automated Workload Repository Reporting 168Summary 171Database Health Check 174Creating New Databases 176Tablespaces and Data Files 178Start-ups and Shut-downs 181Oracle and NLS Parameters 183Generating Database Scripts 186Generating Schema Scripts 188Comparing Database Differences 190Rebuilding multiple Objects 195Top Session Finder 197SGA Trace/Optimization 198Session Browser 200Summary 2038 Exporting Table Data 205Saving Grid Contents 205Flat File Export 208Creating Inserts 209Schema Browser Script 210Oracle Export 211Data Pump Export 214Data Subset Wizard 218Import Table Data 220Summary 2229 Other Useful tools 223Master-Detail Browser 223ER Diagram 227Code Road Map 229Query Builder 232External Tools 238Compare Files 240TNS Editor 241Scripts Manager 243Summary 24510 Toad App Designer 247Toad Command Line 247Toad App Designer 251Summary 260Index 261
