Notice: will be retired soon. Please visit our new site at
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »
Toad Development Suite for Oracle
Visit to buy this product online.
Buy Online »

Toad Development Suite for Oracle

Enabling Database Development Best Practices

The Toad™ Development Suite for Oracle® is a complete set of Oracle® development tools that help guarantee application success through improved code quality, performance, and maintainability. Toad for Oracle provides unmatched team-collaboration capabilities and productivity-enhancing automation. It reduces the risks and costs associated with bugs, performance validation, inconsistent coding standards, dispersed teams with varying skill levels, and more. Plus, it seamlessly integrates with the Toad World™ user community, empowering you to get answers from industry experts, interact with 3 million of your peers, and access a wealth of platform information—all without leaving Toad.


The Toad Development Suite for Oracle enables you to:

  • Deploy high-quality applications that meet user requirements and perform reliably in production
  • Prevent production code from being returned to development
  • Manage development projects and teams with ease
  • Automate PL/SQL code testing to eliminate costly bugs
  • Take up to eight hours of free, web-based training to help you get the most from Toad’s powerful functionality

As a developer, you can:

  • Validate database application performance prior to deployment by testing different user-load scenarios
  • Define measurements for code success and ensure they’re met
  • Build programs according to pre-defined project coding standards and apply code formatting
  • Identify gaps between intended and actual functional code execution
  • Check code quality against a pre-defined list of rules that can be saved on the network or shared among team members
  • Scan code for problematic SQL statements, and with one click, find the most efficient SQL alternative

As a manager, you can:

  • Manage and measure the quality of code produced by your development organization
  • Ensure on-time delivery of optimal code
  • Minimize development and administration costs by automating tasks and ensuring code efficiency and accuracy
  • Reduce the total cost of ownership of Oracle by decreasing the number of bugs deployed to production
  • Produce web-based reports to identify SQL performance and code-quality issues

Sys Reqs

System Requirements

  • 1 GHz processor (Spotlight requires 1.2 GHz processor)
  • 924 MB RAM required, 1 GB recommended
Operating System:
  • Windows 2000, XP, 2003, Vista, 2008 and Windows 7 (32-bit and 64-bit) Notes:
  • When running on a 64-bit operating system, you must use the 32-bit Oracle Client.
  • In Windows Vista, you must use a logon with the Admin privilege or if you are logged on as a normal user, you must have the Universal Access Control (UAC) turned OFF.
Product Exceptions:
  • Quest SQL Optimizer for Oracle: Requires Oracle 8.1.7 or later
  • Spotlight on Oracle: Requires Oracle or later and SQL*Net 2.3.4 or later
  • Toad for Data Analysts: Requires Oracle 9i or later
Additional Requirements:
  • VGA monitor, 1024x768 resolution, small fonts(Spotlight requires 1280x1024 or larger)


Toad now supports the following Cloud databases:

Oracle on Amazon EC2 as well as the following virtualized environments:

  • Citrix support on Windows Server 2003 (Service Pack 2) using the MetaFrame
  • Presentation Server 4.0 and Citrix Presentation
  • Server Clients 10.2
Desktop (VDI):
  • Quest vWorkspace 7.0 on Windows
  • XP Professional 32-bit (Service Pack 2)
  • VMWare ESX Server 3.5 and VMWare
  • Server Console 1.0.10 on Windows Server 2003 (Server Pack 2)

Languages Supported:

  • US English