Toad Development Suite for Oracle

Oracle development tools that enable best practices

Improve code quality, performance and maintainability with ease

Toad™ Development Suite for Oracle® ensures you’re employing PL/SQL development best practices. This comprehensive set of Oracle® database development tools helps guarantee application success through improved code quality, performance, and maintainability. You can use these Oracle developer tools to reduce the risks associated with bugs, performance validation, inconsistent coding standards, dispersed teams with varying skill levels, and more. Toad Development Suite for Oracle also reduces the impact of inefficient coding on productivity, future development cycles, and application performance and availability. 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.


Toad Development Suite for Oracle enables you to employ database development best practices with the following benefits:

  • Helps you meet your requirements and perform reliably in production by deploying high-quality applications
  • Helps you prevent production code from being returned to development
  • Enables you to easily manage development projects and teams
  • Allows you to eliminate costly bugs by automating PL/SQL code testing

As a developer, Toad Development Suite for Oracle offers you these specific benefits:

  • Helps you validate database application performance prior to deployment by testing different user-load scenarios
  • Enables you to define measurements for code success and ensure they’re met
  • Allows you to build programs according to pre-defined project coding standards and then apply code formatting
  • Helps you identify gaps between intended and actual functional code execution
  • Enables you to save a pre-defined set of rules on the network or share among team members, and check them against code quality
  • With just a couple of clicks, you can scan code for problematic SQL statements and find the most efficient SQL alternative

As a manager, Toad Development Suite for Oracle offers you these advantages:

  • Helps you manage and measure the quality of code produced by your development organization
  • Ensures on-time delivery of optimal code
  • Minimizes your development and administration costs by automating tasks and ensuring code accuracy and efficiency
  • Shrinks your total cost of ownership of Oracle by reducing the number of bugs deployed to production
  • Enables you to produce web-based reports to identify SQL performance and code-quality issues

All users:

  • Includes eight hours of free, web-based training to help you take full advantage of Toad’s powerful functionality


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)


  • 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)

Virtualization support

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

Language supported:

  • US English