Introduction to Toad

Toad is a powerful application development tool built around an advanced SQL and PL/SQL editor. Using Toad, you can build and test PL/SQL packages, procedures, triggers, and functions. You can create and edit database tables, views, indexes, constraints, and users. The Schema Browser and Project Manager provides quick access to database objects.

Toad’s SQL Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view and edit Oracle data.

With Toad you can:

View the Oracle Dictionary

Create, browse, or alter objects

Graphically build, execute, and tune queries

Edit PL/SQL and profile stored procedures

Manage your common DB tasks from one central window

Find and fix database problems with constraints, triggers, extents, indexes,and grants

Create code from shortcuts and templates

Create custom code templates

Control code access and development (with or without a third party version control product) using Toad's cooperative source control feature.

PL/SQL Debugger
The optional PL/SQL Debugger lets you step through the code as it executes. With this module you can run a debug session with or without arguments, set breakpoints, watch variables, and more.

Quest DBA Module
The optional Quest DBA Module adds database administration functionality to Toad. With this module you can manage space, compare schemas, monitor database performance, create new databases, maintain redo logs, perform health checks, and more.

From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.