Toad for Oracle Unleashed - Bert Scalzo, Dan Hotka

Toad for Oracle Unleashed

, (Autoren)

Buch | Softcover
288 Seiten
2015
Sams Publishing (Verlag)
978-0-13-413185-6 (ISBN)
45,90 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
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.

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

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

Erscheint lt. Verlag 30.7.2015
Verlagsort Indianapolis
Sprache englisch
Maße 180 x 230 mm
Gewicht 464 g
Themenwelt Informatik Datenbanken Oracle
Mathematik / Informatik Informatik Programmiersprachen / -werkzeuge
Mathematik / Informatik Informatik Software Entwicklung
ISBN-10 0-13-413185-1 / 0134131851
ISBN-13 978-0-13-413185-6 / 9780134131856
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Das umfassende Praxis-Handbuch

von Lutz Fröhlich

Buch | Hardcover (2021)
MITP (Verlag)
29,99
building resilient database solutions for continuous operation

von Stephen Morris

Buch | Softcover (2023)
O'Reilly Media (Verlag)
79,80