Share
Create bookmark
Toad Pocket Reference for Oracle
Notes
Please login to add notes
- 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
- 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
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.
Test the closed alpha on paperc.com
Book Details
Authors
Jeff Smith, Patrick McGrath, and Bert Scalzo
Categories
Computers > Database Management > General
Publishers
Publication year : 2005
License: All rights reserved ©
Times read: 251
