Book description
Toad is an enormously popular interactive environment tool 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. Toad allows developers to browse their database tables, procedures, and object types; use code templates; and show errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics.
Updated for Toad Versions 8.0 and 8.5, this pocket book is 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, SQL Modeler, Schema Browser, Project Manager, and Debugger. The second edition includes coverage of new SQL Editor features, improvements in usability, and new tools such as CodeXpert (a robust code analyzer and advisor) and Script Debugger (the only tool available that provides real-time debugging of SQL*Plus scripts). It also provides helpful hints on using Toad to perform database administration and SQL tuning and optimization.
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.
Table of contents
- Contents
-
Toad Pocket Reference for Oracle
- Introduction
- Toad Basics
-
SQL Editor
- Display
- Toolbars and Menus
- Shortcut Keys
- Supporting Other Parsers/Languages
- Working with Files in the SQL Editor
- Executing Statements
- Using Extended Features (1/2)
-
Using Extended Features (2/2)
- Use the Script Debugger
- Invoke SQL Command Recall
- Display Object Palette (tables, views, synonyms, columns)
- Display code snippets
- Change Active Sessions for this Window
- Make a Non-SQL Code Statement/ Strip All Non-SQL Syntax
- Use the EDIT command
- Use the Toad Describe facility
- Display column dropdown
- Use code templates
- Format code
- Add and remove comments
- Data Grid
- SQL Optimization
- Schema Browser
- Procedure Editor
- Debugger
-
Database Administration
- Using the DBA Module
- Using the Database Browser
- Modifying Oracle Parameters
- Managing Sessions
- Creating and Altering Objects
- Managing Tablespaces
- Checking Extents
- Using Oracle’s Import/Export Tools
- Using Other Toad Import/Export Utilities
- Comparing Schemas and Databases
- Performing SGA Trace Optimization
- Using the HTML Schema Doc Generator
- User Administration
- Project Manager
- Additional Toad Modules
- Index (1/2)
- Index (2/2)
Product information
- Title: Toad Pocket Reference for Oracle, 2nd Edition
- Author(s):
- Release date: May 2005
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596529079
You might also like
book
Oracle PL/SQL Language Pocket Reference, 5th Edition
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference …
book
Oracle Data Guard 11g Handbook
Master Oracle Data Guard 11 g Provide superior data protection, availability, and disaster recovery using the …
book
Oracle Database 11g PL/SQL Programming
Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming …
book
Oracle Database 11g Release 2 Performance Tuning Tips & Techniques
Implement Proven Database Optimization Solutions Systematically identify and eliminate database performance problems with help from Oracle …