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.

Download Free Trial Justify Your Toad

Nav Menu

Contact an expert

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 inefﬁciencies.

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

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

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

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

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.

Key product features

Mac or PC? Your choice

The world’s #1 database management tool is now available for use on PC or Mac, depending on the preferences and needs of your DBAs and developers. This new operating system versatility allows more users worldwide to experience the productivity and efficiency gains Toad brings to the table.

Automation

Reduce the risk of manual errors by automating complex and repetitive tasks like schema compare, script execution, administration, reporting and more. Workflow automations can be shared and scheduled for execution. Automation Designer is available with all editions of Toad for Oracle.

Data modeling

Define the most efficient data structures before building your database schemas or reverse engineer existing data structures into a new data model to make changes or to document. Toad Data Modeler is included with Toad for Oracle DBA Edition.

PL/SQL code profiling

Easily determine why your PL/SQL code is executing slowly by visually exposing performance bottlenecks. The PL/SQL Profiler is available with all editions of Toad for Oracle.

Database health, security and privacy

Assess database health quickly by validating performance, configuration and security vulnerabilities through health check reporting. Database Health Check is available with the DB Admin Module and Toad for Oracle DBA Edition.

Team collaboration

Share standards, best practices, code, scripts, artifacts and more and dramatically improve collaboration and consistency across the development organization. Project Manager is available with all editions of Toad for Oracle.

Miami-Dade County

We have SQL Developer from Oracle, which is free, but our people prefer to use Toad. A lot of times, SQL Developer didn't provide enough functionality.

Sue Camner Senior Operating Systems Programmer and DBA Manager, Miami-Dade County Read Case Study

Large health benefits company

Since 2009 we’ve doubled the number of database professionals using Toad for Oracle, compared to all the other toolsets combined pre-2009. Toad has been very rapidly adopted because everyone knows the Toad name and it has… comprehensive capabilities.

Database engineer and executive advisor at large health benefits company Read Case Study

Major financial services company

We found that Toad has come up with new tools and more capabilities in these tools, like Team Coding. So it was a no-brainer for us to pick Toad.

Senior Manager - Database Management Read Case Study

Tour

Automation Designer

Code Review

utPLSQL Unit Test

Collaboration

Data Redaction

Database Health Check

Profiler

Auto-optimize SQL

Team Coding

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 for PL/SQL code ensures consistent code quality, reduces production defects, improves code coverage and increases 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

OPERATING SYSTEM

Windows 8.1
Windows 10
Windows 11
Windows Server 2012 R2 - 2 CPU required
Windows Server 2016
Windows Server 2019
Windows Server 2022
MacOS 11
MacOS 12
MacOS 13
MacOS14 (Sonoma)

PROCESSOR

1GHz processor
M1/M2 Apple Silicon

MEMORY

1 GB RAM - Toad for Oracle 32 bit

2 GB RAM - Toad for Oracle 64 bit

MAC: 2 GB RAM, 2G Disk

Note: The memory required may vary based on the following:

Applications that are running on your system

Size and complexity of the database

Amount of database activity

Number of concurrent users accessing the database

HARD DISK SPACE

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

DATABASE CLIENT

Oracle 23c
Oracle Client or Instant Client 10.2.0.5
Oracle Client or Instant Client 11.2.0.1/11.2.0.3
Oracle Client or Instant Client 12c Release 1 and 2
Oracle Client or Instant Client 18c
Oracle Client or Instant Client 19c
Oracle Client or Instant Client 21c

DATABASE SERVER

10g Release 2
11g Release 1 and 2
12c Release 1 and 2
18c
19c
21c (Linux and Oracle Cloud Infrastructure)

VIRTUALIZATION SUPPORT

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

CLOUD SUPPORT

Amazon EC2 Oracle Database as a Service and Oracle Database Cloud Service have been tested.

Security Guardian

Automate backup & disaster recovery

Become data driven

Gain comprehensive data protection

Improve your cybersecurity posture

Migrate & consolidate Microsoft workloads

Protect and secure your endpoints

Secure Active Directory and Microsoft 365

Strengthen identity-based security

Browse by Platform

Browse by Industry

Toad for Oracle

Nav Menu

Toad for Oracle

Work across all of your platforms in one single tool with the all new Toad Data Studio!

CI/CD-ready development

Reduce technical debt

Automated performance testing

Simplified SQL Optimization

Risk mitigation

Database performance diagnostics

95%

130K

4M

DevOps-ready development

Team Coding

PL/SQL Unit Testing

Code Review

SQL Optimization

Key product features

Mac or PC? Your choice

Automation

Data modeling

PL/SQL code profiling

Database health, security and privacy

Team collaboration

Miami-Dade County

Large health benefits company

Major financial services company

Tour

Automation Designer

Code Review

utPLSQL Unit Test

Collaboration

Data Redaction

Database Health Check

Profiler

Auto-optimize SQL

Team Coding

Specifications

Resources

Toad for Oracle Datasheet

Upgrading Quest Toad for Greater Security

Toad for Oracle Tips and Tricks

Toad for Oracle - Which Edition is Right for You

How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager

Full E-book: Enabling Agile Database Development with Toad

The Top Five Reasons to Choose Toad Over SQL Developer

Keep Using Toad for Oracle With Databases in the Cloud

Get started now

Related products

Toad Product Line

Toad DevOps Toolkit

Toad Data Point

Toad Intelligence Central

Benchmark Factory for Databases

Support and services

Product Support

Support Offerings

Education Services