TOAD Handbook (2nd Edition)

✍ Scribed by Bert Scalzo, Dan Hotka

• Publisher: Addison-Wesley Professional
• Year: 2009
• Tongue: English
• Leaves: 301
• Edition: 2
• Category: Library

✦ Synopsis

My company recently bought my new license to TOAD 10, and with that cost - I wanted to learn how to use this tool as best I can to increase my productivity using TOAD 10. The book arrived today - and I have been going back and forth between the software and the book - and I am learning things about what it can do - that do not stand out until you have them pointed out. So for me this is a worthwhile purchase.

This is the 2nd Edition of the book (version 9.7 of TOAD), and it went to press in Sept 2009 as version 10 was coming out. So far I am not dissapointed and I expect to be more productive as a result. (TOAD is said to be the most widely used Oracle IDE there is on the windows platform).

The book does try to speak to a large audience, from Novice to Advanced. So there may be parts that may seem elementary- I understand the need to have it in the book(it will have a large audience of users). The version of TOAD that I am using is the Developer edition, so some of the discussions that are for the DBA edition are interesting, however they are not available to use.

The book is clearly written, with some attempts at humour that seem like a joke from a presentation style (It keeps it from being too dry a style).

If you have not really explored TOAD and its abilities before, this will be a useful book and worth the purchase price. I think even the long time users might still get an A-ha moment.

✦ Table of Contents

TOAD Handbook Second Edition (October 2009) (ATTiCA)......Page 1
Table of Contents......Page 10
Acknowledgments......Page 14
About the Authors......Page 16
Who Should Read This Book......Page 18
How This Book Is Organized......Page 19
1 TOAD Setup and Configuration......Page 22
Windows Platform Support......Page 23
Database Connectivity......Page 24
Which Version of TOAD to Use......Page 27
Running the TOAD Installer......Page 29
TOAD Adheres to Oracle Security......Page 30
Advanced TOAD Security Options......Page 32
Customizing TOAD to User Taste......Page 33
Summary......Page 34
2 Database and Schema Browsers......Page 36
Auto-Start a Browser......Page 37
Database Browser......Page 38
Schema Browser......Page 44
Schema Browser Options......Page 59
Summary......Page 61
Basic Concepts of the SQL Editor......Page 62
Predefined Shortcuts......Page 76
User-Defined Shortcuts......Page 79
Using Bind Variables......Page 80
Table and Column Name Select Lists......Page 81
TOAD Table Aliases Substitutions......Page 83
Auto-Replacement Substitutions......Page 84
SQL Templates......Page 85
Code Snippets......Page 87
Executing SQL Statements......Page 88
Executing SQL Scripts......Page 89
Editing Result-Set Data......Page 90
Saving Result-Set Data......Page 92
Printing Result-Set Data......Page 93
Examining Explain Plans......Page 96
Examining Basic Performance Information......Page 99
SQL*Plus Compatibility......Page 101
SQL-Creating-SQL......Page 104
Summary......Page 105
Basic Concepts of the PL/SQL Editor......Page 106
Formatting PL/SQL Code......Page 113
Predefined Shortcuts......Page 115
Using Aliases, Pick Lists, Shortcuts, Snippets, and Auto-Replacement Substitutions......Page 118
PL/SQL Object Templates......Page 119
Executing PL/SQL Code......Page 122
Saving PL/SQL Code to Files......Page 124
Debugging Setup, Requirements, and Parameters......Page 125
Basic Debugging PL/SQL Code......Page 126
Debugging Breakpoint Options......Page 132
Advanced Debugging PL/SQL Code......Page 134
Profiling PL/SQL Code......Page 137
Summary......Page 140
TOAD Report Manager......Page 142
Building Reports Using Fast Reports......Page 148
Adding Reports to the TOAD Report Manager......Page 158
Using the HTML Schema Document Generator......Page 161
Summary......Page 165
Oracle Tuning Using TOAD......Page 166
SQL Explain Plans/Auto Trace......Page 167
Oracle Trace Facility......Page 172
StatsPack Reporting......Page 182
Automated Workload Repository Reporting......Page 185
Summary......Page 188
7 Database Management......Page 190
Database Health Check......Page 191
Creating New Databases......Page 193
Tablespaces and Data Files......Page 195
Start-ups and Shut-downs......Page 198
Oracle and NLS Parameters......Page 200
Generating Database Scripts......Page 203
Generating Schema Scripts......Page 205
Comparing Database Differences......Page 207
Rebuilding Multiple Objects......Page 212
Top Session Finder......Page 214
SGA Trace/Optimization......Page 215
Session Browser......Page 217
Summary......Page 220
Saving Grid Contents......Page 222
Flat File Export......Page 225
Creating Inserts......Page 226
Schema Browser Script......Page 227
Oracle Export......Page 228
Data Pump Export......Page 231
Data Subset Wizard......Page 235
Import Table Data......Page 237
Summary......Page 239
Master-Detail Browser......Page 240
ER Diagram......Page 244
Code Road Map......Page 246
Query Builder......Page 249
External Tools......Page 255
Compare Files......Page 257
TNS Editor......Page 258
Script Manager......Page 260
Summary......Page 262
TOAD Command Line......Page 264
TOAD App Designer......Page 268
Summary......Page 277
A......Page 278
B......Page 279
C......Page 280
D......Page 281
F......Page 284
I......Page 285
M......Page 286
O......Page 287
P......Page 288
R......Page 290
S......Page 291
T......Page 295
U......Page 296
Z......Page 297