| Feature |
Description |
ver 1.2.1 |
ver 1.5.x |
ver 1.5.5 |
ver 2.1.x |
| Download Site |
OTN |
SQL Dev 1.2.1 |
SQL Dev 1.5 |
SQL Dev 1.5.5 |
SQL Dev 2.1 |
| Cost |
FREE |
Yes |
Yes |
Yes |
Yes |
| Oracle Support |
Available through Metalink for customers with a Database Support contract |
Yes |
Yes |
Yes |
Yes |
| Releases |
Initial release: SQL Developer 1.0 (March 2006)
|
|
|
|
|
| |
Release SQL Developer 1.1 (Dec 2006) |
|
|
|
|
| |
Release SQL Developer 1.1.3 (May 2007) |
|
|
|
|
| |
Release SQL Developer 1.2 (June 2007) |
Migrations
APEX integration |
|
|
|
| |
Release SQL Developer 1.2.1 (Aug 2007) |
|
|
|
|
| |
Release SQL Developer 1.5 (April 2008) |
|
|
|
|
| |
Release SQL Developer 1.5.4 (03 March 2009) |
|
Version Control
File Support
Full Translation |
|
|
| |
Release SQL Developer 1.5.5 (July 2009)
|
|
|
Ships with Oracle Database 11gR2 |
|
| |
Release SQL Developer 2.1 (Dec 2009) |
|
|
|
Unit Testing
Data Modeler viewer |
| Architecture |
Java IDE |
Yes |
Yes |
Yes |
Yes |
| |
Connection Navigator |
Yes |
Yes |
Yes |
Yes |
| |
Multiple Connections |
Yes |
Yes |
Yes |
Yes |
| |
DB support (non-Oracle) |
Yes |
Yes |
Yes |
Yes |
| |
Read read only support for Microsoft SQL Server, Microsoft Access, MySQL and Sybase |
Yes |
Yes |
Yes |
Yes |
| Globalization |
Translated UI |
|
Rel 1.5.3 - Japanese
Rel 1.5.4 - 9 Languages |
Yes |
Yes |
| |
Asian / multi-byte |
Yes |
Yes |
Yes |
Yes |
| |
Western European |
Yes |
Yes |
Yes |
Yes |
| Graphical User Interface |
Modern IDE Infrastructure |
Yes |
Yes |
Yes |
Yes |
| |
Online Help |
Yes |
Yes |
Yes |
Yes |
| |
HTML |
Yes |
Yes |
Yes |
Yes |
| |
Shortcut Keys |
Yes |
Yes |
Yes |
Yes |
| Installation |
Footprint |
46M |
72M |
73M |
94M |
| |
Dependencies JDK |
JDK 1.5 update xx |
JDK 1.5 update xx |
JDK 1.5 update xx |
JDK 1.6 update11 + |
| |
Does not require Oracle Home |
Yes |
Yes |
Yes |
Yes |
| Platform Support |
Windows (with Windows Installer ) |
Yes |
Yes |
Yes |
Yes |
| |
Linux (with RPM install) |
Yes |
Yes |
Yes |
Yes |
| |
Mac OS/X |
Yes |
Yes |
Yes |
Yes |
| Database Object Search |
Searches across schema and object types |
Yes |
Yes |
Yes |
Yes |
| |
Extended Search dialog in addition to DB Object search. This allows for searching for objects in code, such as parameters, declaration and usage. |
|
Yes |
Yes |
Yes |
| Advanced Filtering |
Extended filtering:
- Multiple filter options and criteria
- Incorporates AND or OR filtering (All or Any selections)
- Filtering on other users includes OBJECT_COUNT to filter out users with no visible objects |
Yes |
Yes |
Yes |
Yes |
| Schema Filter |
|
|
|
|
Yes |
| Search Engines |
Ask Tom |
Yes |
Yes |
Yes |
Yes |
| |
Oracle doc |
Yes |
Yes |
Yes |
Yes |
| |
Search Doc 11 |
|
Yes |
Yes |
Yes |
| |
Search Doc 10.2 |
Yes |
Yes |
Yes |
Yes |
| |
Search Doc 9.2 |
Yes |
Yes |
Yes |
Yes |
| |
Search Forums |
Yes |
Yes |
Yes |
Yes |
| |
Search Google |
Yes |
Yes |
Yes |
Yes |
| |
Search Metalink |
Yes |
Yes |
Yes |
Yes |
| Menus |
Support for External Tools
|
Yes |
Yes |
Yes |
Yes |
| |
Export DDL and Data |
Yes |
Yes |
Yes |
Yes |
| |
Database Objects Search |
Yes |
Yes |
Yes |
Yes |
| |
Query Builder |
Yes |
Yes |
Yes |
Yes |
| Extensions |
SQL Developer is built on an extensible IDE
- Build full Java extensions
- Use extension hooks for XML
|
Yes |
Yes |
Yes |
Yes |
| Connection Navigator |
Run Manage Database report (right-click for context menu on any connection with privileges, such as SYS or SYSTEM) |
|
Yes |
Yes |
Yes |
| |
Run Manage Database report ( as SYS) to shut down and restart database |
|
Yes |
Yes |
Yes |
| |
Generate DB Doc (right-click for context menu on connections) for all objects in a schema. Open the generated index.html file in a browser to review objects. |
|
Yes |
Yes |
Yes |
| Schema copy |
To copy contents of one schema to another
|
|
Yes |
Yes |
Yes |
| |
Choices include drop objects, truncate and copy |
|
Yes |
Yes |
Yes |
| |
Preview report of actions to be executed |
|
Yes |
Yes |
Yes |
| |
Log report of results |
|
Yes |
Yes |
Yes |
| Schema Diff |
Compare and create SQL Difference statement between 2 schemas
|
|
Yes |
Yes |
Yes |
| |
Select objects to compare |
|
Yes |
Yes |
Yes |
| |
Report of objects to be compared |
|
Yes |
Yes |
Yes |
| |
List of differences and SQL Code to be executed |
|
Yes |
Yes |
Yes |
| |
Run script output to SQL Worksheet to be executed against connection of choice. |
|
Yes |
Yes |
Yes |
| Connections |
Create, save, update and rename connections |
Yes |
Yes |
Yes |
Yes |
| |
Basic Thin JDBC |
Yes |
Yes |
Yes |
Yes |
| |
Custom JDBC URL |
Yes |
Yes |
Yes |
Yes |
| |
TNS Connections |
Yes |
Yes |
Yes |
Yes |
| |
Connections via Connection Manager |
Yes |
Yes |
Yes |
Yes |
| |
Passwords stored encrypted |
Yes |
Yes |
Yes |
Yes |
| |
LDAP Connections |
|
Yes |
Yes |
Yes |
| |
External authentication |
|
Yes |
Yes |
Yes |
| |
Proxy connections |
|
Yes |
Yes |
Yes |
| |
Users prompted for new connection, when password expires |
Yes |
Yes |
Yes |
Yes |
| |
Support for Folders |
|
Yes |
Yes |
Yes |
| |
Create local connections |
|
|
|
Yes |
| |
Proxy connections - Updated support. Password not mandatory for proxy user |
|
|
|
Yes |
| |
Kerberos support extended for thick and thin JDBC driver |
|
|
|
Yes |
| Third Party Access |
Read-only connections to browse objects and data:
- MySQL
- SQL Server
- MS Access
|
Yes |
Yes |
Yes |
Yes |
| |
Read-only connections to browse objects and data:
- Sybase
|
|
Yes |
Yes |
Yes |
| |
Read-only connections to browse objects and data:
- DB2 UDB
-Teradata |
|
|
|
Yes |
| TimesTen |
Integrated TimesTen support |
Yes |
Yes |
Yes |
Yes |
| Browse Objects |
Allow sorting through column headings |
Yes |
Yes |
Yes |
Yes |
| |
View DDL
|
Yes |
Yes |
Yes |
Yes |
| |
View object definitions, e.g. dependencies, details, statistics |
Yes |
Yes |
Yes |
Yes |
| Tables |
Create
-Standard table
-Partitioned
-Index Organized
-Global Temporary External
-Simple Create Table
-Advanced create
-Generate PK Trigger and Sequence
-Lob Parameters
|
Yes |
Yes |
Yes |
Yes |
| |
Sub-partitions displayed as detail records |
|
|
|
Yes |
| |
Modify
-Copy Table
-Normalize Columns
-Create, enable and disable constraints
-Enable and disable related FK constraints
|
Yes |
Yes |
Yes |
Yes |
| |
Table Data
-Table Data Grid Edit
-Duplicate row
-Sort Data
-Filter via SQL Where Clause
-Single record view
-Count rows
-Export
-Browse data (with XMLType columns)
-View CLOB data
|
Yes |
Yes |
Yes |
Yes |
| Views |
Create |
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| |
Modify |
Yes |
Yes |
Yes |
Yes |
| |
Compile Invalid |
Yes |
Yes |
Yes |
Yes |
| |
Update data in updatable views |
Yes |
Yes |
Yes |
Yes |
| Synonyms |
Create
- Object based
- Name based
|
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| |
Modify |
Yes |
Yes |
Yes |
Yes |
| Sequences |
Create |
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| |
Modify |
Yes |
Yes |
Yes |
Yes |
| |
Right-click context menu to alter sequence |
Yes |
Yes |
Yes |
Yes |
Packages, Procedures,
Functions |
Create |
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| |
Run |
Yes |
Yes |
Yes |
Yes |
| |
View PL/SQL Arguments |
Yes |
Yes |
Yes |
Yes |
| |
Compile (Individual selections, All or Invalid) |
Yes |
Yes |
Yes |
Yes |
| |
Compile with Debug |
Yes |
Yes |
Yes |
Yes |
| |
Default skeletal implementation from the spec for "Create Body" |
Yes |
Yes |
Yes |
Yes |
| |
File based PL/SQL support
- Open, edit and save pl/sql files
- Compile pl/sql file against schema to update database |
Yes |
Yes |
Yes |
Yes |
| |
PLSQL code opens in edit mode |
|
|
|
Yes |
| Types |
Create |
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| |
Modify |
Yes |
Yes |
Yes |
Yes |
| Triggers |
Create |
Yes |
Yes |
Yes |
Yes |
| |
Edit Trigger Source |
Yes |
Yes |
Yes |
Yes |
| |
Modify |
Yes |
Yes |
Yes |
Yes |
| |
Triggers tab in master/detail format. Detail displays trigger code |
Yes |
Yes |
Yes |
Yes |
| Database Links |
Create |
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| |
Modify |
Yes |
Yes |
Yes |
Yes |
| |
Test |
Yes |
Yes |
Yes |
Yes |
| Indexes |
Create
-Non-unique
-Unique
-Text Index
-Bitmapped
|
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| Domain Indexes |
Create an index on any existing index type from any accessible schema |
Yes |
Yes |
Yes |
Yes |
| Messages |
Updated Error Display to show more specific to Oracle errors |
Yes |
Yes |
Yes |
Yes |
| |
On Compile, display a success message in the status bar |
Yes |
Yes |
Yes |
Yes |
| Directory |
View Properties |
Yes |
Yes |
Yes |
Yes |
| Materialized Views |
Create |
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| |
Modify |
Yes |
Yes |
Yes |
Yes |
| |
Advanced checkbox
- Define the Select statement declaratively by choosing select items, from objects etc
- Add indexes
- Add partitions |
Yes |
Yes |
Yes |
Yes |
| |
Add indexes for Materialized Views using "New Index" |
Yes |
Yes |
Yes |
Yes |
| Materialized View Logs |
New interface for creating and editing Materialized View Logs |
Yes |
Yes |
Yes |
Yes |
| Queues and Queue Tables |
Browse and view |
|
Yes |
Yes |
Yes |
| Java |
Browse |
|
Yes |
Yes |
Yes |
| |
Load |
|
Yes |
Yes |
Yes |
| |
Updated to support additional editing support. Java objects now supported include CLASS, RESOURCE and SOURCE |
|
|
|
Yes |
| Jobs |
Browse |
|
|
|
Yes |
| Editions |
Oracle 11gR2 Edition support |
|
|
|
Yes |
| Browse Other User Schemas |
|
Yes |
Yes |
Yes |
Yes |
| Recycle Bin |
Purge |
Yes |
Yes |
Yes |
Yes |
| |
Undrop Object |
Yes |
Yes |
Yes |
Yes |
| XML Schemas |
Create |
Yes |
Yes |
Yes |
Yes |
| |
View Properties |
Yes |
Yes |
Yes |
Yes |
| Object Navigator Controls |
Filter/Find |
Yes |
Yes |
Yes |
Yes |
| |
Refresh |
Yes |
Yes |
Yes |
Yes |
| |
Download Grid Data to File |
Yes |
Yes |
Yes |
Yes |
| Users |
Create user with grants and roles etc |
Yes |
Yes |
Yes |
Yes |
| |
Edit user roles, grants and privileges |
Yes |
Yes |
Yes |
Yes |
| Schema Diff |
Compare Source Schema and Objects with Destination schema to produce DDL |
Yes |
Yes |
Yes |
Yes |
| |
Transfer SQL to SQL Worksheet |
Yes |
Yes |
Yes |
Yes |
 DBA Utilities |
Data Management |
Yes |
Yes |
Yes |
Yes |
| |
Database User Management
-Create User
-Alter User
-Drop User
|
Yes |
Yes |
Yes |
Yes |
| |
Generate DDL
-DDL by Object
-DDL by Schema
|
Yes |
Yes |
Yes |
Yes |
| Application Express 3.0.1 |
Connect to and browse all Oracle APEX applications associated with a database schema (At application and page level) |
Yes |
Yes |
Yes |
Yes |
| |
Export and Import Oracle APEX applications using a context menu |
Yes |
Yes |
Yes |
Yes |
| Generate DB Doc |
Generate DB Doc based on object type filter and order |
|
|
|
Yes |
| XML Types |
XML Type tables are visible in the Connections navigator
XML Type columns data can be edited in Data tab |
|
|
|
Yes |
| Data Grids |
Duplicate record button |
Yes |
Yes |
Yes |
Yes |
| |
Single record "pivot" to view and edit one record at a time |
Yes |
Yes |
Yes |
Yes |
| |
Allow columns to be reordered in SQL Worksheet and recall previous order |
Yes |
Yes |
Yes |
Yes |
| |
Calendar prompt for date fields in table data editor |
Yes |
Yes |
Yes |
Yes |
| |
Context Menu on grids |
Yes |
Yes |
Yes |
Yes |
| |
Count Rows with filter |
Yes |
Yes |
Yes |
Yes |
| |
Data grid navigation |
Yes |
Yes |
Yes |
Yes |
| |
Auto resize column widths (on context menu on the data grid and column header) |
Yes |
Yes |
Yes |
Yes |
| |
Copy any selection and paste it anywhere else in the grid |
Yes |
Yes |
Yes |
Yes |
| |
Copy and paste the selection into Excel |
Yes |
Yes |
Yes |
Yes |
| |
Copy a selection from Excel and paste into the data grid |
Yes |
Yes |
Yes |
Yes |
| |
Save SQL from grid as a Report |
|
|
|
Yes |
| |
Find/Highlight records |
|
|
|
Yes |
| |
Manage Columns (Show/Hide) |
|
|
|
Yes |
| |
Filter data on column values |
|
|
|
Yes |
| |
Multiple column sort |
|
|
|
Yes |
| Query Builder |
Create basic query |
Yes |
Yes |
Yes |
Yes |
| |
Run query to test data |
Yes |
Yes |
Yes |
Yes |
| |
Transfer SQL to SQL Worksheet |
Yes |
Yes |
Yes |
Yes |
| Snippets |
Drag and drop snippets onto SQL Worksheet |
Yes |
Yes |
Yes |
Yes |
| |
Manage snippets
- Create new categories
- Create new snippets
|
Yes |
Yes |
Yes |
Yes |
| |
Available in Code Insight |
|
|
|
Yes |
| SQL Worksheet |
Execute statement |
Yes |
Yes |
Yes |
Yes |
| |
Execute statement to multiple data grids |
|
|
|
Yes |
| |
Execute script |
Yes |
Yes |
Yes |
Yes |
| |
Switch connections for worksheet |
Yes |
Yes |
Yes |
Yes |
| |
File support
- Browsing
- Switch connection
- Run
- Edit
- Save
|
Yes |
Yes |
Yes |
Yes |
| |
SQL statement formatting |
Yes |
Yes |
Yes |
Yes |
| |
Bracket matching |
Yes |
Yes |
Yes |
Yes |
| |
Support for displaying output of ref cursors |
Yes |
Yes |
Yes |
Yes |
| |
BLOB, CLOB, xml, cursor support |
Yes |
Yes |
Yes |
Yes |
| |
Code insight on
- table alias
- schema
- partial table + ctrl +[space] (to come)
- ctrl +[space] (to come) |
Yes |
Yes |
Yes |
Yes |
| |
Describe table (F4) |
Yes |
Yes |
Yes |
Yes |
| |
Refine tab names: Set worksheetname 'MyTab Name' |
Yes |
Yes |
Yes |
Yes |
| |
SQL*Plus support (See list below) |
Yes |
Yes |
Yes |
Yes |
| |
Pause long running script |
Yes |
Yes |
Yes |
Yes |
| |
Resume paused script |
Yes |
Yes |
Yes |
Yes |
| |
Select entire row by selecting rownum |
Yes |
Yes |
Yes |
Yes |
| |
XQuery in the SQL Worksheet |
Yes |
Yes |
Yes |
Yes |
| |
SQL History |
Yes |
Yes |
Yes |
Yes |
| |
Dockable SQL History |
|
|
|
Yes |
| |
DBMS Output |
Yes |
Yes |
Yes |
Yes |
| |
Dockable DBMS Output window |
|
|
|
Yes |
| |
OWA Output |
Yes |
Yes |
Yes |
Yes |
| |
Dockable OWA output window |
|
|
|
Yes |
| |
Bind Variable |
Yes |
Yes |
Yes |
Yes |
| |
Commit Options |
Yes |
Yes |
Yes |
Yes |
| |
Autocommit Mode as a preference (not enabled by default ) |
Yes |
Yes |
Yes |
Yes |
| |
Code Formatting |
Yes |
Yes |
Yes |
Yes |
| |
Export to File |
Yes |
Yes |
Yes |
Yes |
| |
Cancel Query |
Yes |
Yes |
Yes |
Yes |
| |
Updated code insight. Allows users to use code completion for a greater number of object types |
Yes |
Yes |
Yes |
Yes |
| |
Replaced SQL Formatting. See SQL Formatter preferences to control white space, tabs, comma placement, case, new line etc. |
Yes |
Yes |
Yes |
Yes |
| |
Code Templates for frequently used code. Create these in Preferences, then through key stroke, in Code Editors and SQL Worksheet, import code template . ctrl+shift+T) |
Yes |
Yes |
Yes |
Yes |
| |
Code Templates are shareable : <user>/Application Data/Sql Developer/CodeTemplate.xml |
Yes |
Yes |
Yes |
Yes |
| |
Flashback. Oracle 11g, you can use flashback on your data. See the Flashback tab on Tables. |
|
Yes |
Yes |
Yes |
| |
Keystroke to change case. (This is also available on a context menu.) Keystroke case is ctrl-quote |
|
Yes |
Yes |
Yes |
| |
Refactor code, see context menu on SQL Worksheet or Code Editors |
|
Yes |
Yes |
Yes |
| |
Separate unshared worksheet for connections for long running queries. Use the keystroke ctrl+shift+N. This will create a separate, unshared worksheet. The unshared worksheets are labeled as follows: HR_ _1 |
|
Yes |
Yes |
Yes |
| |
SQL History stores commands form F5 and F9 keystrokes. i.e Execute script or Execute statement. Note if you run @filename, this is what is stored in the History, not every command from the file .Keystroke ctrl-up and ctrl-down adds and scrolls through previously executed commands in the SQL Worksheet. |
|
Yes |
Yes |
Yes |
| |
Drag and Drop from Navigator to Worksheet for Insert, Update, Delete, Join and Select statements. Set preference. |
|
Yes |
Yes |
Yes |
| |
Data Grid on tables retains Sort.
|
|
Yes |
Yes |
|
| |
Data Grid filter retains drop list of previous filter options |
|
Yes |
Yes |
Yes |
| |
Task Progress |
|
|
|
Yes |
| Tuning |
Autotrace support |
Yes |
Yes |
Yes |
Yes |
| |
Explain plan support |
Yes |
Yes |
Yes |
Yes |
| |
Open *.trc file in SQL Developer for a formatted trace file. |
|
Yes |
Yes |
Yes |
| Editing |
Bookmark OS Files |
Yes |
Yes |
Yes |
Yes |
| |
Bookmarks for PL/SQL DB objects |
Yes |
Yes |
Yes |
Yes |
| |
Code Folding |
Yes |
Yes |
Yes |
Yes |
| |
Code Formatting |
Yes |
Yes |
Yes |
Yes |
| |
Code Insight (code completion) |
Yes |
Yes |
Yes |
Yes |
| |
Code Snippet Viewer |
Yes |
Yes |
Yes |
Yes |
| |
Drag Objects into Editor |
Yes |
Yes |
Yes |
Yes |
| |
File Operations (save, open) |
Yes |
Yes |
Yes |
Yes |
| |
Inline Compilation Errors |
Yes |
Yes |
Yes |
Yes |
| |
Standard Editor Operations |
Yes |
Yes |
Yes |
Yes |
| |
Support File Open with Leading Remarks |
Yes |
Yes |
Yes |
Yes |
| |
Syntax Highlighting |
Yes |
Yes |
Yes |
Yes |
| PL/SQL Debugger |
Inspect Row Types |
Yes |
Yes |
Yes |
Yes |
| |
Set Break Points |
Yes |
Yes |
Yes |
Yes |
| Tuning |
Hierarchical Profiler (Available for connections to 11g R1 and above) |
|
Yes |
Yes |
Yes |
| |
Export grants |
|
Yes |
Yes |
Yes |
| |
Choice of dependent or independent objects |
|
Yes |
Yes |
Yes |
| Supplied Reporting |
Database Session Browsing through master/ detail reports |
Yes |
Yes |
Yes |
Yes |
| |
Export all reports |
Yes |
Yes |
Yes |
Yes |
| |
Import all reports |
Yes |
Yes |
Yes |
Yes |
| |
Increased right click actions |
Yes |
Yes |
Yes |
Yes |
| |
Kill Session |
Yes |
Yes |
Yes |
Yes |
| |
SQL Reporting |
Yes |
Yes |
Yes |
Yes |
| |
Trace Session |
Yes |
Yes |
Yes |
Yes |
| |
Export Report Results to Text, CSV, XLS, XML, HTML, INSERT, Loader |
Yes |
Yes |
Yes |
Yes |
| |
ASH and AWR reports(Available for connections to Oracle 11g R1 and above, and for users licensed for the Oracle Diagnostic pack) |
|
Yes |
Yes |
Yes |
| User Defined Reports |
Charting (select group,series,data from table) |
Yes |
Yes |
Yes |
Yes |
| |
Copy shipped reports and paste as user defined reports |
Yes |
Yes |
Yes |
Yes |
| |
Create and run chart report |
Yes |
Yes |
Yes |
Yes |
| |
Create and run master detail reports |
Yes |
Yes |
Yes |
Yes |
| |
Create a report using a script |
Yes |
Yes |
Yes |
Yes |
| |
Create a report with plsql-dbms_output
e.g. begin dbms_output.put_line('<h1>hello</h1>'); end; |
Yes |
Yes |
Yes |
Yes |
| |
Create a reports with formatted code (e.g. select text from user_source where rownum < 100) |
Yes |
Yes |
Yes |
Yes |
| |
Create reports with gauges |
Yes |
Yes |
Yes |
Yes |
| |
Click through user defined reports using Report Id |
Yes |
Yes |
Yes |
Yes |
| |
Define prompt for bind variables |
Yes |
Yes |
Yes |
Yes |
| |
Drill down links |
Yes |
Yes |
Yes |
Yes |
| |
Creating a user defined report, allow user to browse and bring in a file to populate the SQL |
Yes |
Yes |
Yes |
Yes |
| |
Import and export of user defined reports |
Yes |
Yes |
Yes |
Yes |
| |
Share user defined reports |
Yes |
Yes |
Yes |
Yes |
| |
Open user defined reports created in 1.0 |
Yes |
Yes |
Yes |
Yes |
| |
Create report based off any query from data grids |
|
|
|
Yes |
| Oracle Application Express Report |
Support for browsing Workspaces, applications, pages and schemas |
Yes |
Yes |
Yes |
Yes |
| Additional Reports |
Monitor Sessions report is also on the main Tools menu |
Yes |
Yes |
Yes |
Yes |
| |
Manage Database report on the context menu of the connection in the navigator |
|
Yes |
Yes |
Yes |
| Migration Reports |
Full set of reports to support third-party database migrations |
Yes |
Yes |
Yes |
Yes |
| Third Party Browsing |
Microsoft Access |
Yes |
Yes |
Yes |
Yes |
| |
Microsoft SQL Server |
Yes |
Yes |
Yes |
Yes |
| |
MySQL Database |
Yes |
Yes |
Yes |
Yes |
| |
Sybase Adaptive Server |
|
|
Yes |
Yes |
| |
DB2 UDB |
|
|
|
Yes |
| |
Teradata |
|
|
|
Yes |
| Migration Options |
Quick Migration Wizard offers least privilege migration i.e No DBA privilege is required. |
Yes |
Yes |
Yes |
Yes |
| |
Step driven migration offers control at each stage of the migration process. |
Yes |
Yes |
Yes |
Yes |
| |
Fine grain migration support provides users with the ability to select specific objects for migration. |
Yes |
Yes |
Yes |
Yes |
| |
Complex object migration supports stored procedures, triggers and views |
Yes |
Yes |
Yes |
Yes |
| Translation |
Translation Scratch Editor offers single statement migration. |
Yes |
Yes |
Yes |
Yes |
| |
Translation Difference Viewer provides side by side comparison by matching statements and blocks. |
Yes |
Yes |
Yes |
Yes |
| |
Translate T-SQL to PL/SQL |
Yes |
Yes |
Yes |
Yes |
| |
Translate Access to PL/SQL |
Yes |
Yes |
Yes |
Yes |
| Connections Navigator |
Create a database connection Oracle APEX database schemas |
Yes |
Yes |
Yes |
Yes |
| |
Browse all Oracle APEX applications associated with a database schema, at application and page level |
Yes |
Yes |
Yes |
Yes |
| |
Export and Import Oracle APEX applications using a context menu |
Yes |
Yes |
Yes |
Yes |
| Reporting |
Workspaces |
Yes |
Yes |
Yes |
Yes |
| |
Applications |
Yes |
Yes |
Yes |
Yes |
| |
Pages |
Yes |
Yes |
Yes |
Yes |
| |
Schemas |
Yes |
Yes |
Yes |
Yes |
| Database |
Autotrace |
Yes |
Yes |
Yes |
Yes |
| |
NLS |
Yes |
Yes |
Yes |
Yes |
| |
Third party JDBC Driver |
Yes |
Yes |
Yes |
Yes |
| Accelerator Keys |
Redesigned, now called Shortcut Keys. More Actions... supports the reload of factory settings. |
|
|
|
Yes |
| Environment |
Worksheet |
Yes |
Yes |
Yes |
Yes |
| |
Object Viewer |
Yes |
Yes |
Yes |
Yes |
| |
Open SQL worksheet on connect |
Yes |
Yes |
Yes |
Yes |
| |
Auto-freeze/pin tab |
Yes |
Yes |
Yes |
Yes |
| |
Allow fetch size to be greater than 5000 |
Yes |
Yes |
Yes |
Yes |
| |
SQL Array Fetch size |
Yes |
Yes |
Yes |
Yes |
| |
Support for a startup file such as login.sql. Add file choice to preferences. |
|
Yes |
Yes |
Yes |
| Code editor |
Bookmarks |
Yes |
Yes |
Yes |
Yes |
| |
Insight |
Yes |
Yes |
Yes |
Yes |
| |
Line Gutters |
Yes |
Yes |
Yes |
Yes |
| |
Display settings |
Yes |
Yes |
Yes |
Yes |
| PL/SQL Debugger |
Use probe debugger to Debug PL/SQL |
Yes |
Yes |
Yes |
Yes |
| |
Breakpoints properties |
Yes |
Yes |
Yes |
Yes |
| |
Watches |
Yes |
Yes |
Yes |
Yes |
| |
Inspector |
Yes |
Yes |
Yes |
Yes |
| User Defined Extensions |
Share user defined reports |
Yes |
Yes |
Yes |
Yes |
| |
Add new context menus |
Yes |
Yes |
Yes |
Yes |
| |
Create new tabs |
Yes |
Yes |
Yes |
Yes |
| SQL Formatter |
Increase formatting support |
|
Yes (replaced formatter) |
Yes |
Yes |
| |
Show changes in template code |
|
|
|
Yes |
| Version Control |
Integration with CVS and Subversion |
|
Yes |
Yes |
Yes
(Check for updates for CVS) |
| |
Versioning Navigator
|
|
Yes |
Yes |
Yes |
| |
Create Subversion Repository |
|
Yes |
Yes |
Yes |
| |
Check out and commit files |
|
Yes |
Yes |
Yes |
| |
Branch/Tag |
|
Yes |
Yes |
Yes |
| |
Compare and merge |
|
Yes |
Yes |
Yes |
| |
Resolve conflicts |
|
Yes |
Yes |
Yes |
| Files |
File Navigator for file system file browsing
|
|
Yes |
Yes |
Yes |
| |
View file history |
|
Yes |
Yes |
Yes |
| |
Perforce (Using Check for Updates) |
|
|
|
Yes |
| |
Serena Dimensions (Using Check for Updates) |
|
|
|
Yes |
| Free Model Viewer extension |
Open SQL Developer Data Modeler models |
|
|
|
Yes
|
| |
Drag and Drop create models |
|
|
|
Yes |
| |
View all model properties |
|
|
|
Yes |
| Unit Tests |
Create and update tests |
|
|
|
Yes |
| |
Add tests to suites |
|
|
|
Yes |
| |
Run test reports |
|
|
|
Yes |
| |
Manage lookups
|
|
|
|
Yes |
| |
Manage a library of startups and teardowns |
|
|
|
Yes |
Developer Tools
Printer View