Toad - Powerful Application Development Tool
Sign in

Toad - Powerful Application Development Tool

Sr IT Operation Lead Technical
Toad is a powerful application development tool built around an advanced SQL - PL/SQL editor. Using Toad, you can build and test scripts, 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 provide quick access to database objects.

Toad comes in several editions, each offering different functionality. For more information on the different editions, please see the Toad Editions topic.

Toad’s 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.

Using 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.
  • Create Projects to more easily manage your work

Debugger

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

Quest DBA Module

The 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.

SQL Optimizer

SQL Optimizer (formerly SQL Tuner/SQL Tuning/Xpert Tuning) identifies problematic SQL directly from your code and provides a powerful SQL rewrite engine that ensures the highest statement quality and performance for users of any experience level.

eBiz Module

Lets you quickly find information in your Oracle e-Business Suite about applications, concurrent programs, current and past activity, users, responsibilities, workflows, flex fields, request sets, patches, profile options, printers, menus, invalid objects, data groups, and more.

start_blog_img