Toad for Oracle 12.0 vs. Oracle SQL Developer 3.
2 Functional Matrix
Essential Functionality
Oracle SQL
Developer 3.2
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
Toad for Oracle
Base Edition
Toad for Oracle
Professional
Edition
Toad for Oracle
Xpert Edition
Toad DB Admin
Module
(add-on)
Toad
Development
Suite for Oracle
Toad DBA Suite
for Oracle
Toad DBA Suite
for Oracle
RAC/Exadata Ed.
No spell check
Save, nickname & share previously executed SQL
Unicode support
Query Builder
Integrated Debugger
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
Development Functionality
Automated traditional DBMS_OUTPUT
debugging
Advanced ER Diagram with HTML reporting and email
SQL Developer Data
Modeler Viewer
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.)
View multiple results sets from executed SQL
scripts
Automatically identify unit tests out of synch with
corresponding database source objects
Automate functional code test creation and unit
test execution
No automated test
creation
Team Collaboration
Share common standards and templates
Perform checkpoints through automated code
review validation prior to version control check-in
Manage project assets
Import and Export Code Quality Rules and Rules
Sets for team sharing
Integrates with six version control system
providers
4 VCS providers
Code Analysis and SQL Tuning
PL/SQL profiling to detect code performance
bottlenecks
Visual SQL explain plan
Trace user sessions and visually display Oracle
Trace file output
Display session info & performance metrics
Automate code analysis and validation against
SQL and PL/SQL coding best practices
Automated, configurable, objective code review
& 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 mostefficient 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 suggestions via the
Oracle Tuning Advisor (requires Tuning &
Diagnostics Packs)
Recommend indexing changes based on
continuous database workload assessment
June 2013
Analyze impact of changes to database
environment through index simulation
Toad for Oracle 12.0 vs. Oracle SQL Developer 3.2 Functional Matrix
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
Schema, Data and Change Management
Advanced, highly productive data grids offering
simple column selectivity and grouping
Oracle SQL
Developer 3.2
Toad for Oracle
Base Edition
Toad for Oracle
Professional
Edition
Toad for Oracle Toad DB Admin
Xpert Edition Module (add-on)
Toad
Development
Suite for Oracle
Toad DBA Suite
for Oracle
Toad DBA Suite
for Oracle - RAC
Edition
Analyze the performance impact of moving SQL
statements from database to another
Analyze SQL execution plan changes between
database environments (i.e. dev. vs. prod. or
Oracle 9i vs. 10g)
Import/export data from data grid into/from
Excel files and other formats
Data compare and synch
No column
grouping
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
Compare schemas efficiently with offline snapshot
or definition files
Compare one schema source to multiple targets
Compare and generate Multi Schema change
scripts between two database environments
Generate test data (randomized or real-world)
Oracle Import/Export utilities
Oracle Spatial data support
Oracle Data Mining support
Analyze the performance impact of new indexes,
index changes and parameter changes on SQL
Inc. graphical
representation
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
Reporting
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 212 aspects of database
performance, configuration (inc virtualized
databases and Exadata), schema, RAC and
security vulnerabilities
Multi-database reporting and analysis
dashboard for Oracle RMAN backups
Generate reports on potentially problematic SQL
and optimization results
June 2013
Toad for Oracle 12.0 vs. Oracle SQL Developer 3.2 Functional Matrix
Database Administration
Oracle SQL
Developer 3.2
Control access to protected databases
Toad for Oracle
Base Edition
Toad for Oracle
Professional
Edition
Toad for Oracle
Xpert Edition
Browse multiple servers and databases, perform
tasks and drill down to object level
Browse and navigate database-specific objects
like tablespaces and roles
Export APEX Objects from database
Check database for security vulnerabilities and
usage of Oracle OEM Options and Packs and
produce reports
Toad
Development
Suite for Oracle
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$ (RAC)
and SGA
Toad DB Admin
Module (add-on)
Users can check access Use of OEM Packs by
to OEM Packs in
Toad controlled by
Preferences
Initial Setup Wizard
Execute one or more scripts against one or more
databases
Use of OEM Packs by
Toad controlled by
Initial Setup Wizard
Use of OEM Packs by
Toad controlled by
Initial Setup Wizard
Use of OEM Packs by
Toad controlled by
Initial Setup Wizard
Toad DBA Suite
for Oracle
Toad DBA Suite for
Oracle
RAC/Exadata Edition
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 Windowsbased 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 preempt and mitigate potential future performance
bottlenecks
Performance Diagnostics and Tuning
(Oracle instances)
Integrate with OEM's performance pack with
Oracle tuning advisor *
Identify top sessions and resource-intensive SQL
Perform 161 database health checks including
Performance Configuration and Storage featuring
Virtualized environments
Collect data from Oracle StatsPack or AWR * and
display advisories to correct potential
performance issues
Manage space, repair chained rows and
estimate space usage
Performance Diagnostics and Tuning and
Change Management (Oracle RAC and
Exadata)
Perform 212 database health checks including
Oracle RAC configuration and Exadata
Simple, highly visual alert-based point-and-click
problem resolution for Oracle RAC and Exadata
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
Visualize and diagnose real-time performance
problems in Oracle Exadata environments
including storage server nodes, Smart Scan and
Smart Flash Cache
June 2013
Toad for Oracle 12.0 vs. Oracle SQL Developer 3.2 Functional Matrix
General
Oracle SQL
Developer 3.2
Read-only mode
Toad for Oracle
Base Edition
Toad for Oracle
Professional
Edition
Toad for Oracle
Xpert Edition
Toad DB Admin
Module (add-on)
Toad
Development
Suite for Oracle
Toad DBA Suite
for Oracle
Toad DBA Suite for
Oracle
RAC/Exadata Edition
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 SQL Scripts and Files with the Toad World
Community via a secure public repository
Remotely access and execute SQL scripts via a
web application (MyToad)
Synchronize Toad for Oracle User Files in the
cloud with Dropbox (MyToad)
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***
Restrict access to Toad features
Direct access to feature-based videos
N/A
( Searching multiple
Direct access to product windows, menus,
online locations
options, support portal and online articles/blogs
opens web
on user community with single click using a Jump
browser)
Search bar
Get help from online user community by reading
Blogs/Articles and Participate in forums, with in
the product
External to product, access online community via
web browser
Share SQL Scripts and Files with colleagues within
company network via private repository
Share, schedule and automate tasks across one
or more databases with macro/action record
and playback
Multi-database functionality**
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**
Separate querying on
Oracle, IBM DB2,
MySQL, MS SQL Server,
Access, Teradata and
Sybase Adaptive Server
Integrated tools for query development
including Query Builder and Editor**
Perform heterogeneous queries**
Import & Export utility**
ER Diagram & database browser**
Graphical automation of workflow tasks for reuse and scheduling**
Pivot Tables, charting and comprehensive
reporting**
Import only
* Optional functionality. May access OEM packs. This is disabled by default.
** Delivered through Toad Data Point, available as an add-on to your Toad license.
*** Delivered through Toad Data Modeler, available as an add-on to your Toad license.
Please Note: Dell relies on information from a variety of sources in preparing this document. While every attempt is made to ensure its accuracy, errors or
omissions can occur. In addition, competitive vendors might make changes to their offering after this document is published, potentially affecting the
comparison to Dells offering.
June 2013
