TOAD for Oracle

TOAD for Oracle is a database development and administration tool from Quest Software that simplifies the development and management of Oracle databases. It helps DBAs and developers of all skill levels quickly and accurately design, manage, and maintain Oracle database environments. Toad is commercial software sold as a subscription in Base, Professional, Xpert, Developer and DBA editions, and a 30-day free trial is available.

Features:

• SQL Optimization: The Xpert Edition adds SQL Optimizer, which generates and tests alternative rewrites of slow SQL statements.

• Database Diagrams: Build entity-relationship diagrams of existing tables and their relationships with the ER Diagrammer.

• Schema Comparison & Synchronization: Compare schemas and generate scripts that synchronize the differences.

• Data Pump & Loader Wizards: Run Oracle Data Pump export and import jobs and SQL*Loader tasks through wizards.

• SQL & PL/SQL Editor: Write, format and run SQL and PL/SQL code in an editor with code completion and syntax highlighting.

• Query Builder: Quickly build complex SQL statements using an intuitive drag-and-drop interface.

• Database Monitoring: Watch sessions, locks and instance activity in the Session Browser and Database Monitor windows.

• Database Health Check: Run automated checks of a database instance and review the list of findings.

• Code Analysis: Review PL/SQL code against configurable rules and code-quality metrics (Professional Edition and higher).

• Code Tester: Create and run unit tests for PL/SQL functions and procedures with defined input values.

• Tuning Advisor: Call Oracle's SQL Tuning Advisor from Toad to get recommendations for problem statements.

• Schema Browser: View, create and alter tables, indexes, views, packages and other schema objects in one window.

• PL/SQL Debugger: Step through stored procedures, set breakpoints and watch variable values.

• Data Extraction & Export: Extract data from tables and export it to various formats, including CSV, Excel, HTML and SQL insert statements.

• Database Project Management: Organize connections, scripts and database objects in the Project Manager.

• Test Data Generation: Populate tables with generated test data (Professional Edition and higher).

• Reporting & Documentation: Generate HTML schema documentation with the Schema Doc generator and run built-in reports.

• Team Coding: Work with source control systems such as Git and Subversion directly from Toad.

• Automation Designer: Build and schedule workflows of scripts, exports and reports for re-use.

• Database Administration: The DB Admin Module (DBA Edition) adds tools for storage, users, roles and instance settings.

• Explain Plan: Display the execution plan of a statement to find costly operations.

• Data Dictionary & Metadata: Browse Oracle data dictionary views and object metadata quickly and easily.

Toad for Oracle helps users increase productivity by providing an intuitive graphical interface for database management, query building, and troubleshooting.