Escolha a edição que melhor atende seu negócio

Runs directly on Windows OS

Runs directly on Apple Mac OS X and Linux

Browse and navigate through objects

Create and manipulate database objects through graphical interfaces

Edit: snippets, predictive typing, syntax highlighting, code folding, spell check

Customize code templates and code formatter

Unicode support

Query Builder

Integrated Debugger

Automated traditional DBMS_OUTPUT debugging

Advanced ER Diagram with HTML reporting and e-mail

Build database code dependencies diagram (Code Road Map)

Compare code difference in database objects and files

External/remote debugging (used when the DB code is called from apps. like Java, C++, VB, etc.)

Support for APEX development

Convert embedded SQL to other programming languages (Delphi, C, C++, Java, Perl and VB etc.)

Load and unload multiple Java source files

Store PL/SQL execution parameters for re-use

Browse Oracle Export file content and selectively extract objects and data

Automate functional code test creation and unit test execution

Share common standards and templates

Integrates with 6 version control system providers

Manage project assets

PL/SQL profiling to detect code performance bottlenecks

Trace user sessions and visually display Oracle Trace file output

Visual SQL explain plan

Display session information and performance metrics

Automate code analysis and validation against SQL and PL/SQL coding best practices

Automated, configurable, objective code review and analysis with reports, maximizing code quality

Identify coding best practice violations dynamically during editing.

Identify problematic SQL directly from database objects, files and source code

Automate SQL rewrites to locate the most-efficient SQL alternative (internal to Editor and full external optimizer)

Optimize multiple SQL statements in batch in context with the source code and provide optimized code

Seek Oracle SQL tuning recommendations via the Oracle Tuning Advisor (requires Tuning & Diagnostics Packs)

Recommend indexing changes based on continuous database workload assessment.

Analyze impact of changes to database environment through index simulation.

Test SQL and PL/SQL for scalability under simulated user loads to validate performance under production conditions

Track real-time SQL executions from client applications to help locate issues or perform QA

Track real-time SQL executions on test or development servers to help locate issues or perform QA on client applications

Advanced, highly productive data grids offering simple column selectivity and grouping

Import/export data from data grid into/from Excel files and other formats

Data compare and synch

Display table data representing Parent-Child dependencies (Master Detail Browser)

Reverse engineer objects DDL including roles, permissions to recreate objects in a different db/schema

Compare schemas using live connections or pre-saved offline snapshots

Generate test data (randomized or real-world)

Oracle Import/Export utilities

Oracle Spatial data support

Oracle Data Mining support

Analyze the impact of new indexes and index changes on the database

Analyze SQL execution plan changes between different db environments (i.e. dev. vs. prod. or Oracle 9i vs. 10g)

Replay scalable database workload to simulate production load levels in a test environment prior to deployment or implementation of database or platform changes

Reverse engineer database schema into a physical data model, compare with another version and generate alter script

Reverse engineer physical data model into a platform agnostic conceptual data model

Round-trip engineer from database or DDL between different database platforms such as Oracle, SQL Server, Sybase, DB2, etc

Compare and generate schema change scripts between two or more schema versions

Compare and generate schema change scripts between two or more versions of offline schema snapshot files

Compare and generate database server change scripts between two or more databases

Compare and generate database server change scripts between two or more versions of offline database snapshot files

Generate customizable schema and database reports in HTML format

Automate report generation and distribution

Generate code review reports covering all aspects of code quality assessment

Generate reports on 177 aspects of database performance, configuration (inc virtualized databases), schema, RAC and security vulnerabilities

Generate reports on potentially problematic SQL and optimization results

Control access to protected databases.

Browse multiple servers and databases, perform tasks and drill down to object level

Browse and navigate database-specific objects like tablespaces and roles

Direct access to Oracle Alert log and Oracle Trace files to quickly diagnose issues

Manage database objects, such as tablespaces and rollback segments

Display performance metrics from V$, GV$ and SGA

Check database for security vulnerabilities and usage of Oracle OEM Options and Packs and produce reports

Execute one or more scripts against one or more databases

Integrate with OEM's performance pack with Oracle tuning advisor *

Identify top sessions and resource-intensive SQL

Playback historical activity on Oracle instances to find the source of performance issues

Simple, highly visual alert-based point-and-click problem resolution for Oracle databases including contextual launching from Toad

Simple, highly visual alert-based point-and-click problem resolution for Unix, Linux or Windows-based servers

Performance diagnostics for Oracle Data Guard

Simple, highly visual alert-based point-and-click problem resolution for MySQL databases

Monitoring of Oracle OEM

Perform database predictive diagnostics to pre-empt and mitigate potential future performance bottlenecks

Perform 177 database health checks including Performance Configuration and Storage

Collect data from Oracle StatsPack or AWR * and display advisories to correct potential performance issues

Manage space, repair chained rows and estimate space usage

Simple, highly visual alert-based point-and-click problem resolution for Oracle RAC

Visualize instance, cluster and interconnect levels for Oracle RAC performance diagnostics

Enables DBAs to launch Spotlight on Oracle directly in context with an instance exhibiting performance issues

Playback historical activity to find the source of performance issues

Perform industry standard benchmark testing on Oracle RAC to determine optimum CPU/node configuration

Replay database workload to simulate production load levels in a test Oracle RAC environment prior to deployment or implementation of RAC configuration, database or platform changes

Read-only mode

Restrict access to Toad features

Direct access to knowledge and educational content on user community and other resources using a search bar

Context-sensitive PL/SQL knowledge base, including best practices, worked examples, error messages and much more

Distribute and optionally enforce configurations and settings to group of users

Share, schedule and automate tasks across one or more databases with macro/action record and playback

Query and report on multiple database platforms: Oracle, SQL Server, DB2, MySQL, Access, Teradata, Netezza, PostgreSQL, Sybase IQ, Sybase SQL Anywhere, Vertica and more from a single interface**

Integrated tools for query development including Query Builder and Editor**

Perform heterogeneous queries**

Import & Export utility**

Perform heterogeneous queries**

ER Diagram & database browser**

Data compare and sync across different database platforms**

Graphical automation of workflow tasks for re-use and scheduling**

Pivot Tables, charting and comprehensive reporting**

Reverse engineer database schema into a physical data model, compare with another version and generate alter script***

Reverse engineer physical data model into a platform agnostic conceptual data model***

Round-trip engineer from database or DDL between different database platforms such as Oracle, SQL Server, Sybase, DB2, Ingres, etc***