Home > Store > Data > SQL

Toad for Oracle Unleashed

Register your product to gain access to bonus material or receive a coupon.

Toad for Oracle Unleashed

Best Value Purchase

Book + eBook Bundle

  • Your Price: $53.99
  • List Price: $89.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $39.99
  • List Price: $49.99
  • Usually ships in 24 hours.

eBook (Watermarked)

  • Your Price: $31.99
  • List Price: $39.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Description

  • Copyright 2016
  • Dimensions: 7" x 9"
  • Pages: 288
  • Edition: 1st
  • Book
  • ISBN-10: 0-13-413185-1
  • ISBN-13: 978-0-13-413185-6

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.

Extras

Related Article

An Interview with Bert Scalzo and Dan Hotka on Toad for Oracle

Author's Site

Please visit the author's sites at bertscalzo.com and danhotka.com.

Sample Content

Online Sample Chapter

Toad for Oracle Unleashed: Working with SQL

Sample Pages

Download the sample pages (includes Chapter 3 and Index)

Table of Contents

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

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership