Toad Pocket Reference for Oracle

by McDaniel, Jim; McGrath, Patrick

• ISBN13: 9780596003371
• ISBN10: 0596003374
• Format: Paperback
• Copyright: 2002-08-01
• Publisher: Oreilly & Associates Inc

Summary

TOAD -- the Tool for Oracle Application Developers -- is an enormously popular interactive environment for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. TOAD makes developers far more productive; using TOAD, you'll find that program changes that once took hours can now be completed in minutes. In addition to its development features, TOAD also provides extensive facilities for Oracle database administration. Coauthored by the TOADman and TOAD team, and Patrick McGrath of Quest Software, Inc., this pocket reference is a helpful companion for Oracle developers and DBAs. It's packed with quick-reference material: TOAD feature and menu summaries, shortcut keys, suggested changes to TOAD defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic TOAD components: the SQL Editor, Procedure Editor, Text Editor, SQL Modeler, Schema Browser, and Debugger. It also provides helpful hints on using TOAD to perform database administration and SQL tuning. Whether you're a new or experienced TOAD user, you'll find this quick reference an indispensable companion to the product and its online help files. Book jacket.

Author Biography

known as TOADman to his many admirers, the developer of TOAD is a cult hero in the Oracle world. When he speaks at conferences, his sessions are mob scenes. He is revered on the Web for his helpful postings. Jim is now the lead support for the commercial version of TOAD which is marketed by Quest Software.

is a technical marketing representative at Quest Software.

Table of Contents

Foreword	p. 1
Introduction	p. 2
Contributors	p. 2
Caveats	p. 4
For Help with TOAD	p. 4
Conventions	p. 5
TOAD Basics	p. 6
Expanding TOAD's Functionality	p. 6
TOAD Startup Options	p. 8
The TOAD.ini File	p. 10
TOAD Menu Toolbar	p. 10
TOAD Standard Toolbar	p. 12
SQL Editor	p. 13
SQL Editor Options	p. 15
SQL Editor Display	p. 19
SQL Editor Toolbars and Menus	p. 19
SQL Editor Shortcut Keys	p. 23
Supporting Other Parsers/Languages	p. 26
Opening Files in the SQL Editor	p. 26
Source Control in the SQL Editor and Procedure Editor	p. 27
Using FTP and Other Networking Utilities with TOAD	p. 28
Using the TOAD Describe Facility	p. 28
SQL Editor Windows	p. 29
Executing SQL with the SQL Editor	p. 32
Additional SQL Editor Features	p. 36
Using the Results Panel	p. 40
Editing Data in the SQL Editor's Data Grid	p. 46
Procedure Editor	p. 50
Procedure Editor Options	p. 51
Configuring the Procedure Editor	p. 53
Procedure Editor Display	p. 53
Procedure Editor Menus and Toolbars	p. 54
Populating the Procedure Editor	p. 55
Procedure Editor Shortcut Keys	p. 57
Using the Procedure Editor	p. 58
Text Editor	p. 62
SQL Modeler	p. 62
Schema Browser	p. 63
Schema Browser Display	p. 64
Schema Browser Options	p. 65
Schema Browser Commands	p. 67
SQL Tuning	p. 73
Explain Plans	p. 74
SQL Tuning Commands	p. 75
Oracle Probe API	p. 78
Additional Tuning	p. 79
Debugger	p. 79
Setting Debugger Options	p. 80
Debugger Menus and Toolbar	p. 81
Debugger Display	p. 82
Setting Parameters	p. 84
Executing a Stored Program from the Debugger	p. 85
Executing a Stored Program Without Debugging	p. 85
After Debugging	p. 86
Other TOAD Menus	p. 86
The Tools Menu	p. 86
The Create Menu	p. 91
The Help Menu	p. 94
TOAD Database Administration	p. 94
Using the TOAD-DBA Module	p. 95
Monitoring the Database	p. 96
Performing User Administration	p. 106
Performing Database Export/Import	p. 107
Additional TOAD Modules	p. 111
Debugger	p. 112
SQL Tuning Lab	p. 112
Knowledge Xperts	p. 112
TOAD-DBA Module	p. 113
The TOAD Suite	p. 113
Index	p. 115
Table of Contents provided by Syndetics. All Rights Reserved.