Oracle SQL Developer Feature List

Date: Mar 2010

This document provides a comprehensive listing of features available in Oracle SQL Developer. For a list of SQL Developer 2.1 new features see new New Features 2.1.

Feature Areas

 

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
Refactor Surround with FOR. WHILE, or PL/SQL Block       Yes
  Quick outline       Yes
Import Data Import data from spreadsheet (XLS format) into a table using SQL Developer   Yes Yes Yes
  Create table from xls spreadsheet import   Yes Yes Yes
  Import from CSV   Yes Yes 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
Export DDL Export DDL allows the inclusion of drop objects   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
  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