TOAD Pocket Reference for 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

      Foreword  

      Introduction  

                Contributors  

                Caveats  

                For Help with TOAD  

                Conventions  

      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  

      Debugger  

                Setting Debugger Options  

                Debugger Menus and Toolbar  

                Debugger Display  

                Setting Parameters  

                Executing a Stored Program from the Debugger  

                Executing a Stored Program Without Debugging