TOAD Pocket Reference for Oracle

Jim McDaniel, Patrick McGrath

  • 出版商: O'Reilly
  • 出版日期: 2002-09-05
  • 售價: $584
  • 貴賓價: 9.5$555
  • 語言: 英文
  • 頁數: 128
  • 裝訂: Paperback
  • ISBN: 0596003374
  • ISBN-13: 9780596003371
  • 相關分類: Oracle




The Tool for Oracle Application Developers (TOAD) is a popular graphical user interface for the Oracle database that allows programmers to build, test, debug, an format their code within an interactive development environment. With the easy-to-use TOAD interface, changes that once took hours can be done in just minutes. TOAD allows developers to browse their database tables, procedures and object types, use code templates, and shows errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics.

The only book in print for the current version of TOAD (7.4), the TOAD Pocket Reference for Oracle , provides Oracle developers and DBAs with quick reference to TOAD?s main features, shortcut keys, recommended changes to options, and productivity tips and tricks. The book covers:

  • An introduction to TOAD and its main program functions
  • How to customize TOAD and change its options to suit your work environment
  • SQL Editor (and data grid)
  • Procedure Editor
  • PL/SQL Debugger
  • Schema Browser
  • TOAD-DBA module (add-on module)

Written by TOADman (Jim McDaniel, the creator of TOAD) and Patrick McGrath, this book provides a concise pocket-sized guide that?s easy to carry anywhere. Developers and DBAs will find the TOAD Pocket Reference for Oracle an indispensable companion.

Table of Contents


            For Help with TOAD

     TOAD Basics
            Expanding TOAD's Functionality
            TOAD Startup Options
            The TOAD.ini File
            TOAD Menu Toolbar
            TOAD Standard Toolbar

     SQL Editor
            SQL Editor Options
            SQL Editor Display
            SQL Editor Toolbars and Menus
            SQL Editor Shortcut Keys
            Supporting Other Parsers/Languages
            Opening Files in the SQL Editor
            Source Control in the SQL Editor and Procedure Editor
            Using FTP and Other Networking Utilities with TOAD
            Using the TOAD Describe Facility
            SQL Editor Windows
            Executing SQL with the SQL Editor
            Additional SQL Editor Features
            Using the Results Panel
            Editing Data in the SQL Editor's Data Grid

     Procedure Editor
            Procedure Editor Options
            Configuring the Procedure Editor
            Procedure Editor Display
            Procedure Editor Menus and Toolbars
            Populating the Procedure Editor
            Procedure Editor Shortcut Keys
            Using the Procedure Editor

     Text Editor

     SQL Modeler

     Schema Browser
            Schema Browser Display
            Schema Browser Options
            Schema Browser Commands

     SQL Tuning
            Explain Plans
            SQL Tuning Commands
            Oracle Probe API
            Additional Tuning

            Setting Debugger Options
            Debugger Menus and Toolbar
            Debugger Display
            Setting Parameters
            Executing a Stored Program from the Debugger
            Executing a Stored Program Without Debugging