- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
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 applicationsON THE WEB:Download all examples and source code presented in this book from informit.com/title/9780134131856 as it becomes available.
Contents
Introduction xiWho Should Read This Book xiWhy This Book Is Unique xiiHow This Book Is Organized xii1 Getting Started 1Introduction to Toad 1Toad Release History 2Toad Editions and Suites 3Prerequisites and Installation 5Running Toad the First Time 8Oracle Client Software 9Database Connections 10Introduction to Main Screens 16Basic Toad Customizations 18Common Newbie Questions 21Can Toad Do That? 21Toad versus Database Security 22Sharing Toad Options Settings 22Help-Toad Running Slowly 22Summary 23 2 Fast Track 25Organizing Connections 25Toolbars and Menus 30Keyboard Shortcut Keys 33Startup Windows/Screens 34Startup Files, Scripts, and Actions 36Advanced Toad Customizations 37Sharing Toad Settings 40Summary 41 3 Working with SQL 43Editor Window 43SQL Editor Output Area 48Object Describe 51Toad Insights 57Code Snippets 58SQL Recall 60Auto Replace 63Query Builder 64Summary 68 4 Schema Browser 69Configuring the Schema Browser 69Creating and Editing Objects 76Printing Data Using FastReport 79Using the Reports Manager 85Summary 91 5 Working with Data 93Reviewing Data Grid Options 93Filter/Sort the Table Data 97View/Edit Query 99Show/Hide Columns 100Show Detail Dataset 100Calculate Selected Cells 101Export Dataset 102Refresh Dataset 103Cancel Query Execution or Fetch 104Add/Delete Rows 104Row Set Navigation Buttons 105Edit Row Set Control Buttons 105Commit/Rollback 105Bookmark Navigation 105Single Record Viewer 105Save Data in Various Formats 106Master Detail Browser 111ER Diagrammer 113HTML Documentation Generator 115Summary 119 6 Working with PL/SQL 121Using the Editor 121Using Code Templates 127Project Manager 132Using Code Snippets 133Code Shortcuts 135Code Analysis 139Using the Debugger 142Basic Debugging 142Advanced Debugging Techniques 148Using the PL/SQL Profiler 153Summary 156 7 Miscellaneous Tools 157Code Road Map 157External Tools 160Compare Files 163TNS Editor 164Script Manager 165UNIX Monitor 167Summary 169 8 Getting Started with Toad Automation 171Command Line (Legacy) 172Automation Designer (Future) 180Summary 190 9 Database Administration 191Health Check 192Session Browser 194Database Browser 197Simple Export 202Data Pump Export 205Tablespace Management 210Generate Database Script 212Generate Schema Script 214Compare Databases 216Compare Schema 218Analyze All Objects 220Rebuild Multiple Objects 223Summary 224 10 Toad as a SQL Tuning Tool 227Toad and Explain Plans 227SQL Statistics 231Toad and SQL Trace 233Toad and TKPROF 238Toad and Trace File Browser 241Statspack Interface 243AWR Browser 245Toad and the PL/SQL Profiler 246Toad and the SQL Optimizer 248Summary 249 Index 251
