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

Toad for Oracle

Modernize your Oracle database operations to enable business agility

You’re under pressure to take on more database responsibilities and work faster than ever before. This, combined with declining resources, 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. Toad is the only developer tool of its kind that will simplify your workflow, help reduce code defects and improve code quality and performance while supporting team collaboration. On the operations side, you can automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation. You can also use Toad for Oracle - Sensitive Data Protection to define, search for and protect sensitive data across all your Oracle databases quickly and easily.

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.
OF THE FORTUNE 500
trust quest software
customers
in 100 countries
online
community members

Team Coding

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

PL/SQL Unit Testing

Available in all Toad editions: New testing module supports test-driven development by enabling developers to write tests before writing code.

Toad offers a unit test facility for every skill set. Use the UI in Code Tester to write the PL/SQL needed for your tests or write the PL/SQL yourself in the new utPLSQL unit test module.

Code Review

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

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.

    Automation Designer

  • Automate complex and repetitive tasks like schema compare, script execution, administration, reporting and more.

  • Code Review

  • Ensure consistent code quality standards to reduce problems in production and improve the maintainability of the code for the future.

  • utPLSQL Unit Test

  • Creating unit tests prior to coding ensures consistent code quality, fewer production issues and easier code maintainability.

  • Collaboration

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

  • Data Redaction

  • Protect selected data that is shown to users in real time without requiring changes to the application.

  • Database Health Check

  • Ensure the health of all Oracle databases with configurable checks.

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

  • Auto-optimize SQL

  • Automatically generate and compare alternate SQL rewrites and choose the best alternative.

  • 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 12c R2
  • Oracle 10g R2 through 12c R2
  • Toad has been tested on Oracle Exadata 2.0 running Oracle database 12c R2
  • 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

Toad for Oracle
Datasheet
Toad for Oracle
Toad for Oracle
Develop and manage Oracle databases with less time and effort.
Read Datasheet
Which Toad for Oracle Edition is Right for You?
Datasheet
Which Toad for Oracle Edition is Right for You?
Which Toad for Oracle Edition is Right for You?
Develop and manage Oracle databases with less time and effort.
Read Datasheet
How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
Technical Brief
How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
Technical Brief: Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
Read Technical Brief
Full E-book: Enabling Agile Database Development with Toad
E-book
Full E-book: Enabling Agile Database Development with Toad
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.
Read E-book
How Are DBAs Really Managing Their Data?
Infographic
How Are DBAs Really Managing Their Data?
How Are DBAs Really Managing Their Data?
See the infographic for more information about database management trends – and how to best utilize the insights gained from all types of data sources.
View Infographic
The Top Five Reasons to Choose Toad Over SQL Developer
Technical Brief
The Top Five Reasons to Choose Toad Over SQL Developer
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.
Read Technical Brief
Getting Agile with Database Development
E-book
Getting Agile with Database Development
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.
Read E-book
Major Financial Firm Advances DevOps with Trusted Database Tools
Case Study
Major Financial Firm Advances DevOps with Trusted Database Tools
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 da

Read Case Study

Get started now

Modernize your Oracle database operations to enable business agility

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.