Oracle Technology Network
Developer Tools
SQL Developer
Developer Tools
SQL Developer
Oracle SQL Developer Feature List
Date: March 2011 This document provides a comprehensive listing of features available in Oracle SQL Developer. For a list of SQL Developer 3.0 new features see new New Features 3.0.
|
| About | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Download Site | OTN | SQL Dev 1.5 | SQL Dev 1.5.5 | SQL Dev 2.1.1 | SQL Dev 3.0 |
| 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) | |||||
| 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 | ||||
| Release SQL Developer 2.1.1 (Mar 2010) | |||||
| Release SQL Developer 3.0 (Feb 2011) | Full Data Modeler DBA Navigator Query Builder | ||||
| Architecture | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | 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 | 72M | 73M | 94M | 147M |
| Dependencies JDK | JDK 1.5 update xx | JDK 1.5 update xx | JDK 1.6 update11 + | 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 | 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 | Yes | |||
| Schema Browser | Navigation between object types and schemas for a specific connection | Yes | |||
| Support fast client-side name based filtering | Yes | Yes | |||
| Search Engines | Ask Tom | Yes | Yes | Yes | Yes |
| Oracle doc | Yes | Yes | Yes | Yes | |
| Search Doc 11 | Yes | 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 | 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 | Yes |
| Run Manage Database report ( as SYS) to shut down and restart database | Yes | 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 | Yes | |
| Schema copy | To copy contents of one schema to another | Yes | Yes | Yes | Yes |
| Choices include drop objects, truncate and copy | Yes | Yes | Yes | Yes | |
| Preview report of actions to be executed | Yes | Yes | Yes | Yes | |
| Log report of results | Yes | Yes | Yes | Yes | |
| Schema Diff | Compare and create SQL Difference statement between 2 schemas | Yes | Yes | Yes | Yes |
| Select objects to compare | Yes | Yes | Yes | Yes | |
| Report of objects to be compared | Yes | Yes | Yes | Yes | |
| List of differences and SQL Code to be executed | Yes | Yes | Yes | Yes | |
| Run script output to SQL Worksheet to be executed against connection of choice. | Yes | Yes | Yes | Yes | |
| Oracle Application Express | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | |
| Connections Navigator | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | Yes | Yes | Yes | Yes |
| Sub-partitions displayed as detail records | Yes | Yes | |||
Modify | Yes | Yes | Yes | Yes | |
Table 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 | 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 | 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 | 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 | Yes |
| Java | Browse | Yes | Yes | Yes | Yes |
| Load | Yes | Yes | Yes | Yes | |
| Updated to support additional editing support. Java objects now supported include CLASS, RESOURCE and SOURCE | Yes | Yes | |||
| Jobs | Browse | Yes | Yes | ||
| Editions | Oracle 11gR2 Edition support | Yes | 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 | Yes | Yes | Yes | Yes | |
Generate DDL | 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 | Yes | ||
| XML Types | XML Type tables are visible in the Connections navigator XML Type columns data can be edited in Data tab | Yes | Yes | ||
| DBMS Scheduler | Create and schedule Programs | Yes | |||
| Define Schedules | Yes | ||||
| Schedule and group Jobs | Yes | ||||
| Create Chain steps and define Chain Rules | Yes | ||||
| Assign username/password Credentials to jobs | Yes | ||||
| Specify a Database Destination to run a remote database job | Yes | ||||
| Spatial Data Management | Identify tables/views and materialized views that contain spatial datatype columns | Yes | |||
| Define/Validate spatial metadata and indexes | Yes | ||||
| Show and manipulate spatial data instances on a new 'map' view | Yes | ||||
| Interact with objects on the map view | Yes | ||||
| Validate spatial data instances | Yes | ||||
| Database Connections | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | Yes | |
| External authentication | Yes | Yes | Yes | Yes | |
| Proxy connections | Yes | Yes | Yes | Yes | |
| Users prompted for new connection, when password expires | Yes | Yes | Yes | Yes | |
| Support for Folders | Yes | Yes | Yes | Yes | |
| Create local connections | Yes | Yes | |||
| Proxy connections - Updated support. Password not mandatory for proxy user | Yes | Yes | |||
| Kerberos support extended for thick and thin JDBC driver | Yes | Yes | |||
| Third Party Access | Read-only connections to browse objects and data: | Yes | Yes | Yes | Yes |
Read-only connections to browse objects and data: | Yes | Yes | Yes | Yes | |
| Read-only connections to browse objects and data: - DB2 UDB -Teradata | Yes | Yes | |||
| TimesTen | Integrated TimesTen support | Yes | Yes | Yes | Yes |
| Data Miner | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Free extension to SQL Developer | Yes | ||||
| Simplifies and automates the data mining process | Yes | ||||
| Mine data and define, save and share advanced analytical methodologies | Yes | ||||
| Visualize data, perform data transformations for data mining | Yes | ||||
| Build, evaluate and apply classification, clustering, anomaly detection, text mining, market basket predictive models | Yes | ||||
| Use the SQL and Java APIs to build applications to automate knowledge discovery | Yes | ||||
| Data Modeler | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Data Model Viewer extension | Yes | ||||
| Open data models and properties | Yes | Yes | |||
| Drag and drop to create models | Yes | Yes | |||
| Full Data Modeler support | Yes | ||||
| Write access to design and develop data models | Yes | ||||
| DBA Navigator | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Database Configuration | Yes | ||||
| Resource Manager | Yes | ||||
| Security | Yes | ||||
| Storage | Yes | ||||
| Exporting and Importing | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Import Data | Import data from spreadsheet (XLS format) into a table using SQL Developer | Yes | Yes | Yes | Yes |
| Create table from XLS spreadsheet import | Yes | Yes | Yes | Yes | |
| Import from CSV | Yes | Yes | Yes | Yes | |
| Customizable user interface based on Preference settings | Yes | ||||
| Dynamic data preview | Yes | ||||
| Delimited file support | Yes | ||||
| Staging External Table load method provides generation of an external table | Yes | ||||
| Export Data | Export data for more than one table at a time (with or without DDL) | Yes | Yes | Yes | Yes |
| Export to -CSV - XML - Text - HTML - XLS - SQL Insert Statements - SQL*Loader Syntax | Yes | Yes | Yes | Yes | |
| PDF Support | Yes | ||||
| Export DDL | Export DDL allows the inclusion of drop objects | Yes | Yes | Yes | Yes |
| INSERT data statement for multiple tables | Yes | Yes | Yes | Yes | |
| Option to suppress schema name | Yes | Yes | Yes | Yes | |
| Export full schema with single click | Yes | Yes | Yes | Yes | |
| Export to file, worksheet or clipboard from context menu | Yes | Yes | Yes | Yes | |
| Export grants | Yes | Yes | Yes | Yes | |
| Choice of dependent or independent objects | Yes | Yes | Yes | Yes | |
| Delimited file support | Yes | ||||
| Extended object search capability to include schema and object type | Yes | ||||
| Export data from views and materialized views | Yes | ||||
| Options to write output to a single file, separate files for each object, separate files for each object type, and files into separate directories by object type | Yes | ||||
| Exporting - PDF Support | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Customizable Layouts | Yes | ||||
| Binary Large Object Support | Yes | ||||
| Document Compression | Yes | ||||
| Meta data | Yes | ||||
| PDF Generation | Yes | ||||
| Security | Yes | ||||
| Version Support | Yes | ||||
| Migrations and Third Party Database support | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | Yes | ||
| DB2 UDB | Yes | Yes | |||
| Teradata | Yes | 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 | |
| Full command line support | Yes | ||||
| Server Capture support | Yes | ||||
| Project support for Migrations | Yes | ||||
| Application Scanning and Migration for Sybase DBLIB and CTLIB applications | Yes | ||||
| Migration Project Estimation | Yes | ||||
| Migration Reports | Yes | ||||
| Improved identifier and name mapping | 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 | |
| Preferences | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | 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 | 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 | Yes |
| Show changes in template code | Yes | Yes | |||
| Reporting | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | 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 | 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 | Yes | |
| Migration Reports | Full set of reports to support third-party database migrations | Yes | Yes | Yes | Yes |
| SQL and PL/SQL Editing | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | |
| Debug Anonymous Blocks | Yes | ||||
| Run and Debug Procedures with REF Cursors | Yes | ||||
| Parser | Yes | ||||
| Tuning | Hierarchical Profiler (Available for connections to 11g R1 and above) | Yes | Yes | Yes | Yes |
| SQL Tuning Advisor | Yes | ||||
| Diff Tool for Explain Plans | Yes | ||||
| Management Pack Licensing Preferences | Yes | ||||
| Refactor | Surround with FOR. WHILE, or PL/SQL Block | Yes | Yes | ||
| Quick outline | Yes | Yes | |||
| SQL Worksheet | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| 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 | Yes | |||
| Find/Highlight records | Yes | Yes | |||
| Manage Columns (Show/Hide) | Yes | Yes | |||
| Filter data on column values | Yes | Yes | |||
| Multiple column sort | Yes | 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 | |
| Query Builder Viewer | Yes | ||||
| Automatic Join Creation | Yes | ||||
| Multiple Join Types | Yes | ||||
| Grouping, Predicates, Sorting | Yes | ||||
| Derived Tables, Sub-Queries, and Unions | 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 | Yes | |||
| SQL Worksheet | Execute statement | Yes | Yes | Yes | Yes |
| Execute statement to multiple data grids | Yes | Yes | |||
| Execute script | Yes | Yes | Yes | Yes | |
| Switch connections for worksheet | Yes | Yes | Yes | Yes | |
File support | 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 | Yes | |||
| DBMS Output | Yes | Yes | Yes | Yes | |
| Dockable DBMS Output window | Yes | Yes | |||
| OWA Output | Yes | Yes | Yes | Yes | |
| Dockable OWA output window | Yes | 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 | Yes | |
| Keystroke to change case. (This is also available on a context menu.) Keystroke case is ctrl-quote | Yes | Yes | Yes | Yes | |
| Refactor code, see context menu on SQL Worksheet or Code Editors | Yes | 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 | 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 | Yes | |
| Drag and Drop from Navigator to Worksheet for Insert, Update, Delete, Join and Select statements. Set preference. | Yes | Yes | Yes | Yes | |
Data Grid on tables retains Sort. | Yes | Yes | Yes | ||
| Data Grid filter retains drop list of previous filter options | Yes | Yes | Yes | Yes | |
| Task Progress | Yes | 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 | Yes | |
| SQL Tuning Advisor | Yes | ||||
| Diff Tool for Explain Plans | Yes | ||||
| Management Pack Licensing Preferences | Yes | ||||
| Times Ten | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Free extension to SQL Developer | Yes | Yes | |||
| Browse, create, and edit TimesTen database objects including tables, views, indexes, sequences, materialized views, PL/SQL packages, procedures and functions | Yes | Yes | |||
| Create and drop cache groups | Yes | Yes | |||
| Perform cache group operations Load, Refresh, Unload and Flush | Yes | Yes | |||
| Alter autorefresh intervals, status and aging properties of cache groups | Yes | Yes | |||
| Query and update data in regular and cache tables | Yes | Yes | |||
| Run, edit, compile and create PL/SQL packages, procedures and functions | Yes | Yes | |||
| Define and alter data aging policies on tables | Yes | Yes | |||
| Grant, revoke and view system and object privileges | Yes | Yes | |||
| Update and view table and column statistics | Yes | Yes | |||
| View execution plans | Yes | Yes | |||
| Execute TimesTen built-in procedures and selected ttIsql command in SQL Worksheet | Yes | Yes | |||
| Connect to multiple Oracle TimesTen and Oracle databases | Yes | Yes | |||
| Export data from Oracle and TimesTen tables in ttBulkCp format | Yes | Yes | |||
| Create and run user-defined reports | Yes | Yes | |||
| Support Oracle TimesTen and In-Memory Database Cache 11g and 7.0 | Yes | Yes | |||
Program unit arguments, source code search and source code line counts for PL/SQL packages, procedures and functions | Yes | ||||
| System and object privileges granted to the user connected to the TimesTen database | Yes | ||||
| Names of all tables owned by the user connected to the TimesTen database | Yes | ||||
| Listing of all internal and external database users | Yes | ||||
| Create and drop public and private synonyms | Yes | ||||
| Create and drop materialized view logs | Yes | ||||
| Cache an Oracle private synonym. | Yes | ||||
| Update table and column statistics used by the query optimizer for all tables owned by the user connected to the TimesTen database | Yes | ||||
| Compile invalid or all PL/SQL packages, procedures and functions | Yes | ||||
| View and update the data | Yes | ||||
| Unit Testing | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Create and update tests | Yes | Yes | |||
| Add tests to suites | Yes | Yes | |||
| Run test reports | Yes | Yes | |||
Manage lookups | Yes | Yes | |||
| Manage a library of startups and teardowns | Yes | Yes | |||
| Advanced Data Types Support | Yes | ||||
| Multi-user support | Yes | ||||
| Multiple startups/teardowns | Yes | ||||
| Purge run results | Yes | ||||
| Rename test implementation | Yes | ||||
| Test synchronization and retargeting test | Yes | ||||
| Export tests | Yes | ||||
| Support for Complex datatypes | Yes | ||||
| Version Control | |||||
| Feature | Description | ver 1.5.x | ver 1.5.5 | ver 2.1.x | ver 3.0 |
| Version Control | Integration with CVS and Subversion | Yes | Yes | Yes (Check for updates for CVS) | Yes |
Versioning Navigator | Yes | Yes | Yes | Yes | |
| Create Subversion Repository | Yes | Yes | Yes | Yes | |
| Check out and commit files | Yes | Yes | Yes | Yes | |
| Branch/Tag | Yes | Yes | Yes | Yes | |
| Compare and merge | Yes | Yes | Yes | Yes | |
| Resolve conflicts | Yes | Yes | Yes | Yes | |
| Files | File Navigator for file system file browsing | Yes | Yes | Yes | Yes |
| View file history | Yes | Yes | Yes | Yes | |
| Perforce (Using Check for Updates) | Yes | Yes | |||
| Serena Dimensions (Using Check for Updates) | Yes | Yes | |||
| File Based Debugging | Yes | ||||
Printer View