Brief Overview of Oracle SQL Developer

 

Updated March 2011


SQL Developer Brief Overview

Oracle SQL Developer is a free graphical tool for database development. The initial release, in March 2006, provided users with a graphical interface to interact with database objects by providing the ability to browse the database, run SQL, PL/SQL and SQL*Plus statements, execute SQL scripts, and edit and debug PL/SQL statements. This initial release also provide a suite of reports to further interrogate the dictionary. SQL Developer 1.0 was quickly followed by 2 patch releases and the SQL Developer 1.1 in December 2006.

This document contains an overview of current and previous releases of SQL Developer.
 

Current Release

Oracle SQL Developer 3.0 (March 2011)

Oracle SQL Developer 3.0 provides a broad range of new functionality, including a new Query Builder, DBA navigator and Schedule builder. The latest release includes significant updates to the Import and Export functionality and adds more support for tuning your SQL code. For more detail on these and other new features see the following documents:

Previous Releases

Oracle SQL Developer 2.1 (Dec 2009)

SQL Developer 2.1 introduced PL/SQL Unit Testing and the integrated Data Modeler viewer, along with a number of other new features, such as the updated SQL Worksheet and additions to the Third party database migration support. See the 2.1 Release Notes and Release 2.1 New Feature list for more details.

Oracle SQL Developer 2.1.1 (March 2010)

Oracle SQL Developer 2.1.1 is a patch release to SQL Developer 2.1. This patch release resolves a number of the issues raised and addresses a few additional feature requests raised on the SQL Developer Exchange. See the 2.1.1 Release Notes.

Oracle SQL Developer 1.1 (Dec 2006)

The main goal of SQL Developer 1.1 was to bring file-based PL/SQL Editing to the user base, while also broadening the general offering of the tool.

SQL Developer 1.1.x patches

  • SQL Developer 1.1.1 (January 2007)
  • SQL Developer 1.1.2 (March 2007)
  • SQL Developer 1.1.3 (May 2007)
    SQL Developer 1.1.3 is shipped with Oracle Database 11g Release 1.

Oracle SQL Developer 1.2 (June 2007)

Oracle SQL Developer 1.2 was known as the "Migration Release", as it included the Developer Migration Workbench, tightly integrated with Oracle SQL Developer to provide users with a single point to browse database objects and data in third party databases, and to migrate from these databases to Oracle...Read more...

Additionally SQL Developer 1.2 includes support for Oracle Application Express 3.0.1(Oracle APEX). Read more...

SQL Developer 1.2.x patches

  • SQL Developer 1.2.1 a patch release to 1.2 (August 2007)

Oracle SQL Developer 1.5 (April 2008)

Oracle SQL Developer 1.5 is the "Version Control" release, as it includes integration with open source version control products, CVS and Subversion .Supporting the version control is a File Browser to browse and read files stored in the file system. You can open and edit these files from within SQL Developer.

In addition to this central addition to SQL Developer, release 1.5 includes many updated features, such as SQL Formatting, Schema Compare, Copy and Export wizards and the addition of migration support for Sybase.

Times Ten support is also integrated with the product.

Feature Listings

SQL Developer 1.5.x release detail

  • SQL Developer 1.5.1 a patch release to 1.5 (June 2008)
  • SQL Developer 1.5.3 is the first translation release supporting Japanese (December 2008)
  • SQL Developer 1.5.4 is the first full translation release supporting Japanese, Spanish, Italian, German, French, Brazilian Portuguese, Simplified Chinese and Korean (March 2009)
  • SQL Developer 1.5.5 is shipped with Oracle Database 11g Release 2 (July 2009)
  • SQL Developer 1.5.6 is bundled and released with Oracle JDeveloper 11g (July 2009)

Oracle SQL Developer 2.1 (December 2009)

Released in December 2009, Oracle SQL Developer 2.1 introduces two new significant new features, PL/SQL Unit Testing and the Data Modeler Viewer, in addition to the ongoing addition of multiple other feature requests. SQL Developer 2.1 expands the Database Migration support by adding support for DB2 UDB and Teradata. Perforce and Serena Dimensions are additions to the version control tools now supported. For a full list of features in SQL Developer and to see a list of SQL Developer 2.1 new features, please see the following documents.

 

To find out more about the new Migration Workbench, see this dedicated site on OTN.