For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Toad for Oracle

Modernize your Oracle database operations to enable business agility. Toad® for Oracle is the only developer tool that helps you simplify your workflow, reduce code defects and improve code quality and performance while supporting team collaboration. Automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation. Define, search for and protect sensitive data across all your Oracle databases quickly and easily.
Toad for Oracle
Toad for Oracle product overview 01:07

You’re under pressure to take on more database responsibilities and work faster than ever before. Combined with declining resources, this puts your critical databases and cloud native applications at risk. But what if you could use a single toolset to speed Oracle SQL development and database administration while improving performance? With Toad for Oracle, you’ll reduce costs and risks by easily ensuring the health and performance of your Oracle Cloud Platform and on-premises databases.

CI/CD-ready development

Promote DevOps processes and reduce work with continuous integration and continuous deployment.

Reduce technical debt

Ensure functional accuracy and coding best practices to minimize code defects.

Automated performance testing

Ensure production scalability with automated workload replay testing.

Simplified SQL Optimization

Simplify and automate SQL optimization for developers; advanced SQL and index optimization for DBAs.

Risk mitigation

Accelerate application delivery, while minimizing risks associated with database changes.

Database performance diagnostics

Quickly pinpoint and resolve database performance inefficiencies.

95%

of the Fortune 500 trust Quest Software

130K

Customers in 100 countries

4M

Online community members

DevOps-ready development

Team Coding
PL/SQL Unit Testing
Code Review
SQL Optimization
Team Coding

Team Coding

Integrates with your preferred source control system and provides collaborative access to schema objects. This allows Team Coding to reconcile changes with the corresponding files in source control, thus simplifying and streamlining the developer experience.
PL/SQL Unit Testing

PL/SQL Unit Testing

Available in all Toad editions: suitable for PL/SQL developers more familiar with unit testing, utPLSQL testing is a great way to help reduce code defects as you write your code.

Code Review

Code Review

Define coding standards from a selection of over 200 rules to ensure development teams can correct code as they type and consistently improve overall quality. This makes it easier to maintain code in the future and reduces the likelihood of defects.
SQL Optimization

SQL Optimization

A simple interface that really solves the problem of SQL tuning for developers and reduces the burden on DBAs. SQL Optimizer’s patented re-writing algorithm quickly finds alternative versions of the original SQL statement that will run faster in the database.

Product feature add-ons

Automation

Reduce the risk of manual errors by automating complex and repetitive tasks like schema compare, script execution, administration, reporting and more.

Data modeling

Define the most efficient data structures before building your schemas and reverse engineer existing data structures.

PL/SQL code profiling

Easily determine why your code is executing slowly by visually exposing performance bottlenecks.

Database health and security

Assess database health quickly by validating performance, configuration and security vulnerabilities through health check reporting.

Team collaboration

Share standards, best practices, code, scripts, artifacts and more with your team or across the development organization.

Data privacy and auditing

Find and protect sensitive data and then apply Oracle’s Data Redaction, Data Encryption and audit policies to secure and track data access.

Tour

Automation Designer
Code Review
utPLSQL Unit Test
Collaboration
Data Redaction
Database Health Check
Profiler
Auto-optimize SQL
Team Coding
Automate complex and repetitive tasks like schema compare, script execution, administration, reporting and more.

Automation Designer

Automate complex and repetitive tasks like schema compare, script execution, administration, reporting and more.
Ensure consistent code quality standards to reduce problems in production and improve the maintainability of the code for the future.

Code Review

Ensure consistent code quality standards to reduce problems in production and improve the maintainability of the code for the future.
Creating unit tests for PL/SQL code ensures consistent code quality, reduces production defects, improves code coverage and increases maintainability

utPLSQL Unit Test

Creating unit tests for PL/SQL code ensures consistent code quality, reduces production defects, improves code coverage and increases maintainability
Share standards, best practices, code, scripts, artifacts and more with your team or across the development organization.

Collaboration

Share standards, best practices, code, scripts, artifacts and more with your team or across the development organization.
Protect selected data that is shown to users in real time without requiring changes to the application.

Data Redaction

Protect selected data that is shown to users in real time without requiring changes to the application.
Ensure the health of all Oracle databases with configurable checks.

Database Health Check

Ensure the health of all Oracle databases with configurable checks.
Times the execution of each line of PL/SQL code, storing the data in a repository and representing it graphically to display performance bottlenecks.

Profiler

Times the execution of each line of PL/SQL code, storing the data in a repository and representing it graphically to display performance bottlenecks.
Automatically generate and compare alternate SQL rewrites and choose the best alternative.

Auto-optimize SQL

Automatically generate and compare alternate SQL rewrites and choose the best alternative.
Controls and monitors the check-out/check-in of the PL/SQL code files in source control.

Team Coding

Controls and monitors the check-out/check-in of the PL/SQL code files in source control.

Specifications

  • Windows 7 (32-bit and 64-bit) to Windows 10
  • Windows Server 2008 R2 to 2012 R2 (64-bit)
  • 1GHz processor
  • 32-bit: 1GB RAM
  • 64-bit: 2GB RAM
  • 800MB — Toad for Oracle Base Edition
  • 1GB — Toad Developer Edition for Oracle
  • 530MB — Toad for Oracle Professional Edition
  • 2GB — Toad DBA Edition for Oracle
  • 625MB — Toad for Oracle Xpert Edition
  • 2GB — Toad DBA Edition for Oracle RAC and Exadata Editions
  • Oracle client or instant client 10g R2 through 19c
  • Oracle 10g R2 through 19c
  • Application: Citrix XenApp 5.0 and 6.5 have been tested
  • Server: Oracle VM 3.1 has been tested
  • Desktop: vWorkspace 7.0 has been tested
  • VMware ESX Server 3.5, 4.0 and 5.5 have been tested
  • Amazon EC2 Oracle Database as a Service and Oracle Database Cloud Service have been tested.

Resources

Datasheet

Toad for Oracle

Develop and manage Oracle databases with less time and effort.
Technical Brief

Upgrading Quest Toad for Greater Security

This Technical Brief details Quest’s adherence to software security standards for continually testing and delivering versions of Toad products that you can safely install and run.
Datasheet

Which Toad for Oracle Edition is Right for You?

Develop and manage Oracle databases with less time and effort.
Technical Brief

How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager

Technical Brief: Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
E-book

Full E-book: Enabling Agile Database Development with Toad

This paper will show you how, by implementing Toad for Oracle Developer Edition and Toad DevOps Toolkit, the database development organization can actually become agile.
Technical Brief

The Top Five Reasons to Choose Toad Over SQL Developer

In this tech brief, Toad® expert John Pocknell reveals how it's not only possible, but is in fact quite likely, that you'll wind up saving more money with Toad than you will with SQL Developer — even though the latter is free.
E-book

Getting Agile with Database Development

Once your organization becomes convinced of the advantages of agile development, there is no going back. Shorter time to value, lower risk and greater flexibility are among the most frequently cited benefits of the agile mentality.
Case Study

Major Financial Firm Advances DevOps with Trusted Database Tools

Senior executives at a major financial firm committed to Agile development and DevOps to spur innovation. But their database professionals needed proof that integrating the company’s vital databases into the workflow would not lead to data loss. Using Toad and Toad DevOps Toolkit, the company

Get started now

Modernize your Oracle database operations to enable business agility
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos

Support and services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.

Education Services

Training courses delivered through online web-based, on-site or virtual instructor-led.