Toad for Oracle Unleashed
1st Edition
Published on 29. June 2015
288 pages
978-0-13-413189-4 (ISBN)
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 applications
ON THE WEB:
Download all examples and source code presented in this book from informit.com/title/9780134131856 as it becomes available.
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 applications
ON THE WEB:
Download all examples and source code presented in this book from informit.com/title/9780134131856 as it becomes available.
More details
Series
Language
English
Place of publication
Boston
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
ISBN-13
978-0-13-413189-4 (9780134131894)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Bert Scalzo | Dan Hotka
Toad for Oracle Unleashed
Book
07/2015
Sams Publishing
€45.79
Article exhausted; check different version
Persons
Bert Scalzo is a Database Expert for HGST (a Western Digital company) and was formerly at Dell Software as a member of the Toad dev team for 15 years. He has worked with Oracle databases for more than two decades. Mr. Scalzo's work history includes time at both Oracle Education and Oracle Consulting. He holds several Oracle Masters certifications and has an extensive academic background-including a BS, MS, and PhD in Computer Science, an MBA, plus insurance industry designations. Mr. Scalzo is also an Oracle ACE.
Mr. Scalzo is an accomplished speaker and has presented at numerous Oracle conferences and user groups, including OOW, ODTUG, IOUG, OAUG, RMOUG, and many others.
He has written several books and numerous articles, papers, and blogs for the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ, and Toad World.
http://bertscalzo.com/
Dan Hotka is a Training Specialist and an Oracle ACE Director who has more than 37 years in the computer industry, and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.
Dan Hotka, Author/Instructor/Oracle ACE Director
www.DanHotka.com
Dan@DanHotka.com
DanHotka.Blogspot.com
Mr. Scalzo is an accomplished speaker and has presented at numerous Oracle conferences and user groups, including OOW, ODTUG, IOUG, OAUG, RMOUG, and many others.
He has written several books and numerous articles, papers, and blogs for the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ, and Toad World.
http://bertscalzo.com/
Dan Hotka is a Training Specialist and an Oracle ACE Director who has more than 37 years in the computer industry, and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.
Dan Hotka, Author/Instructor/Oracle ACE Director
www.DanHotka.com
Dan@DanHotka.com
DanHotka.Blogspot.com
Content
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
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
