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 for Oracle

Simply the Best Productivity Tool for Oracle Database Professionals

Toad™ for Oracle® is unrivaled for ensuring the greatest possible productivity in development and administration of Oracle® databases. Only Toad combines the deepest functionality available with extensive automation and intuitive workflows. 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. With Toad, database professionals of all skill and experience levels can collaborate and work efficiently and accurately.

This Oracle database tool is available in a variety of editions to meet the unique needs of your job function.

Features

Not everyone works with Oracle databases in the same way, which is why we offer six different editions of Toad for Oracle. Whatever your job function is, there’s a version of Toad that’ll simplify your work.

Recommended Toad Edition by Job Function:

Application Developers – The Toad for Oracle Xpert Edition gives you the power to build, edit, and format code in your Oracle database, as well as eliminate performance issues in your code. With automated SQL optimization, accessible directly from the Toad Editor, the Xpert Edition makes Oracle PL/SQL performance concerns a thing of the past.

PL/SQL Developers – The Toad Development Suite for Oracle is a complete set of Oracle development tools that ensures application success through improved code quality, performance, and maintainability. It reduces the costs associated with bugs, performance inefficiencies, inconsistent coding standards, and dispersed teams with varying skill levels.

Database Administrators – The Toad DBA Suite for Oracle enables you to become more proactive and productive by automating maintenance and other tasks, ensuring optimal performance, and mitigating the risk of change. By greatly reducing the risks associated with database vulnerability, performance, upgrades, patches, and more, Toad ensures efficiency and alleviates stress. We also offer an Oracle RAC edition of this suite.

See a comprehensive list of Toad for Oracle’s functionality.

Sys Reqs

Client Requirements:

  • Intel® Pentium® PC
  • 1 GB RAM and 120 MB disk space for Toad™ for Oracle® 32-bit
  • 2 GB RAM and 150 MB disk space for Toad for Oracle 64-bit
  • Oracle Client 9.2.0.8, 10.2.0.3, 11.2.0.1, 12.1
  • Or Instant Client 10.2.0.4, 11.2.0.3, 12.1

Server Requirements:

  • Oracle 8.0.6; 8.1.7; 9i; 9i R2; 10g, 10g R2; 11g, 11g R2, 12c
  • Any hardware platform

Cloud database service:

  • Oracle databases running on Amazon® EC2®

Virtualization support:

  • Application: Citrix® XenApp® 5.0 and 6.5
  • Desktop: Dell™ v Workspace™ 7.0
  • Server: Oracle® VM 3.1, VMware® ESX 3.5

For a complete list, please refer to the release notes.

Videos

Screenshots

Schema Browser

Schema Browser

Toad’s venerable Schema Browser is the go-to tool for visualizing objects at the schema level or the database level.

Project Manager

Project Manager

The Project Manager is a highly functional tool for organizing and personalizing many disparate elements in the database.

ER Diagram

ER Diagram

Toad’s new ER Diagram tool hosts a feature-rich interface for modeling complex data structures.

Editor Debug

Editor Debug

Toad’s expansive Editor features debugging capabilities, allowing the user to step through code while monitoring output.

Editor SQL extract

Editor SQL extract

Toad 11 introduces the SQL Extract feature, which enables the user to pull DML from larger PL/SQL code and execute it.

Auto Optimize window

Auto Optimize window

Extract and optimize embedded SQL – without copying it to a separate Editor tab.

Auto Optimize window

Auto Optimize window

The Auto Optimize window writes alternative queries that users can compare to the original statements.

Code Analysis window

Code Analysis window

Scan and analyze database objects and PL/SQL files for code correctness in the Code Analysis window.

DB Health Check

DB Health Check

Write customized explanations for each DB check item through the DB Health Check feature.

DB Health Check Report

DB Health Check Report

The DB Health Check Report Output tab lists Health Check results. Users can save the results as HTML output.

Docs

Case Studies

Avion Uses Toad to Improve Database Reporting Accuracy and Performance for U.S. Army Aviation Operations Cisco Systems Standardizes on Toad and Doubles Developer Productivity ECAD Protects Musical Rights for Thousands of Brazilian Artists with Toad Excellent Management Systems Uses Toad® Development Suite to Help Customer Successfully Fight Compliance Lawsuit, Saving Tens of Millions of Dollars Florida Keys Community College Gains Full ROI with Toad for Oracle Within One Week of Deployment Imerys Terre Cuite optimise ses bases de données avec Toad for Oracle DBA Suite de Quest Software Maine Transitions to Oracle RAC with Help from Toad DBA Suite for Oracle RAC Edition Miami-Dade County Relies on Toad for Fast and Effective Application Development and Database Administration Quest Automates GCNet’s Data Replication Process to Deliver More Than 100 Percent ROI Quest Reduces Toad Licensing Hassles and Costs for Texas Commission on Environmental Quality Spotlight on Oracle with RAC Diagnostics Significantly Reduces Production Downtime for Pace University State of Vermont IT Staff Uses Toad DBA Suite for Oracle to Easily Find Bottlenecks, Saving 10 Hours of DBA Time Each Week Toad Boosts Oracle Performance and Saves Money for World's Largest Online Bank Toad for Oracle Xpert Provides KPIT Cummins with Accurate Code to Improve Efficiency in Database Administration and Performance Toad for Oracle Xpert Reduces SQL Query Time for Ithaca College from 10 Minutes to 0.09 Seconds Toad Simplifies Management of Generali's Various Oracle Databases While Increasing Developer Productivity and Protecting Code Toad® Dramatically Decreases Development Time for AXA Financial Toad® Helps a Large University Ace Its PeopleSoft Implementation with Improved SQL Quality and Staff Productivity Toad® Reduces Time Spent on Daily Tasks from Hours to Minutes for American Electric Power University of Massachusetts Medical School Reduces Risk while Doubling IT Staff Productivity with Toad Walter Reed Army Medical Center Leverages Toad to Improve Patient Care back to top

Technical Briefs

DBAs, Developers and Analysts - Everyone Can Benefit from Toad for Oracle Deliver Better Applications using Database Development Best Practices Discover the Hidden Treasures of Toad Effectively Managing Oracle Standard Edition Databases with Toad DBA Suite for Oracle How Toad™ DBA Suite for Oracle® 12.0 Complements Oracle® Enterprise Manager 12c Optimizing SQL Statements in SQR Predicting Oracle Performance Issues Predictive Diagnostics: Performance Modeling Public Sector Solution Brief: The Blackboard Academic Suite and Quest Software Simplify the Database Development and Administration of Your High-performance e-Learning Applications Realize the Power of Connected Intelligence with Toad for Oracle Searching for the Right Oracle IDE? An Examination of Toad for Oracle's Value Over Other Oracle IDEs Secrets of the Dell SQL Optimizer SQL Optimizer for Oracle v8.7: New Features Technical Brief - What's New in Spotlight on Oracle 9.5 Testing: A Critical Aspect of Development Best Practices The Benefits of Upgrading Your Toad® for Oracle License The Top Five Reasons to Choose Toad Over SQL Developer The Value of Good Database Development Software - Expert Evaluation of SQL Developer and Toad Development Suite Three-Step Process for Ensuring High-Performing and Scalable SQL Toad for Oracle v12 Tips and Tricks Toad for Oracle... and Java? Toad Says RAC 'Em Up! Top Five Reasons to Choose Toad Over DBArtisan What's New in Toad for Oracle 11.6 What's New in Toad for Oracle 12.5 Workload Capture and Replay back to top