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.