SPECIAL OFFER
Use code BACKTOLEARN during checkout to save 50% on books, eBooks, & videos. Shop now.
Register your product to gain access to bonus material or receive a coupon.
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…
ON THE WEB:
Download all examples and source code presented in this book from informit.com/title/9780134131856 as it becomes available.
An Interview with Bert Scalzo and Dan Hotka on Toad for Oracle
Please visit the author's sites at bertscalzo.com and danhotka.com.
Toad for Oracle Unleashed: Working with SQL
Download the sample pages (includes Chapter 3 and Index)
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