Toad for Oracle Unleashed

Book 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

    Download all examples and source code presented in this book from as it becomes available.

    Table of contents

    1. About This eBook
    2. Title Page
    3. Copyright Page
    4. Contents at a Glance
    5. Table of Contents
    6. About the Authors
    7. Dedication
    8. We Want to Hear from You!
    9. Reader Services
    10. Introduction
      1. Who Should Read This Book
      2. Why This Book Is Unique
      3. How This Book Is Organized
    11. Chapter 1. Getting Started
      1. Introduction to Toad
        1. Toad Release History
        2. Toad Editions and Suites
        3. Prerequisites and Installation
      2. Running Toad the First Time
        1. Oracle Client Software
        2. Database Connections
        3. Introduction to Main Screens
        4. Basic Toad Customizations
      3. Common Newbie Questions
        1. Can Toad Do That?
        2. Toad versus Database Security
        3. Sharing Toad Options Settings
        4. Help—Toad Running Slowly
      4. Summary
    12. Chapter 2. Fast Track
      1. Organizing Connections
      2. Toolbars and Menus
      3. Keyboard Shortcut Keys
      4. Startup Windows/Screens
      5. Startup Files, Scripts, and Actions
      6. Advanced Toad Customizations
      7. Sharing Toad Settings
      8. Summary
    13. Chapter 3. Working with SQL
      1. Editor Window
      2. SQL Editor Output Area
      3. Object Describe
      4. Toad Insights
      5. Code Snippets
      6. SQL Recall
      7. Auto Replace
      8. Query Builder
      9. Summary
    14. Chapter 4. Schema Browser
      1. Configuring the Schema Browser
      2. Creating and Editing Objects
      3. Printing Data Using FastReport
      4. Using the Reports Manager
      5. Summary
    15. Chapter 5. Working with Data
      1. Reviewing Data Grid Options
        1. Filter/Sort the Table Data
        2. View/Edit Query
        3. Show/Hide Columns
        4. Show Detail Dataset
        5. Calculate Selected Cells
        6. Export Dataset
        7. Refresh Dataset
        8. Cancel Query Execution or Fetch
        9. Add/Delete Rows
        10. Row Set Navigation Buttons
        11. Edit Row Set Control Buttons
        12. Commit/Rollback
        13. Bookmark Navigation
        14. Single Record Viewer
      2. Save Data in Various Formats
      3. Master Detail Browser
      4. ER Diagrammer
      5. HTML Documentation Generator
      6. Summary
    16. Chapter 6. Working with PL/SQL
      1. Using the Editor
      2. Using Code Templates
      3. Project Manager
      4. Using Code Snippets
      5. Code Shortcuts
      6. Code Analysis
      7. Using the Debugger
        1. Basic Debugging
        2. Advanced Debugging Techniques
      8. Using the PL/SQL Profiler
      9. Summary
    17. Chapter 7. Miscellaneous Tools
      1. Code Road Map
      2. External Tools
      3. Compare Files
      4. TNS Editor
      5. Script Manager
      6. UNIX Monitor
      7. Summary
    18. Chapter 8. Getting Started with Toad Automation
      1. Command Line (Legacy)
      2. Automation Designer (Future)
      3. Summary
    19. Chapter 9. Database Administration
      1. Health Check
      2. Session Browser
      3. Database Browser
      4. Simple Export
      5. Data Pump Export
      6. Tablespace Management
      7. Generate Database Script
      8. Generate Schema Script
      9. Compare Databases
      10. Compare Schemas
      11. Analyze All Objects
      12. Rebuild Multiple Objects
      13. Summary
    20. Chapter 10. Toad as a SQL Tuning Tool
      1. Toad and Explain Plans
      2. SQL Statistics
      3. Toad and SQL Trace
        1. Toad and TKProf
        2. Toad and Trace File Browser
      4. Statspack Interface
      5. AWR Browser
      6. Toad and the PL/SQL Profiler
      7. Toad and the SQL Optimizer
      8. Summary
    21. Index
    22. Code Snippets

    Product information

    • Title: Toad for Oracle Unleashed
    • Author(s): Bert Scalzo, Dan Hotka
    • Release date: July 2015
    • Publisher(s): Sams
    • ISBN: 9780134131900