Oracle SQL Developer Statement of Direction

Updated June 2009

Oracle SQL Developer

 Oracle SQL Developer enhances productivity and simplifies database development tasks by providing a graphical interface for browsing database objects, creating and updating objects and running SQL statements and scripts. Using SQL Developer you can create, edit and debug PL/SQL statements, and create and run reports. SQL Developer supports connections to and migrations from third-party databases; MySQL, Microsoft SQL Server, Microsoft Access and Sybase Adaptive Server, and users can work with files using the integrated Subversion and CVS version control support. SQL Developer connects to any Oracle Database version 9.2.0.1 and later and supports a variety of platforms including Windows, Linux and Mac OSX.

SQL Developer was initially released as an early adopter on the 28th of December 2005. Since initial production in March 2006, SQL Developer has maintained a position of the second most downloaded product on OTN after the database, and by May 2008 had passed 1 million downloads, with over 1.2 million users. Oracle SQL Developer ships Oracle Database 11gR1 and is included in the Oracle JDeveloper 11g.

Future Releases

The next release product for release from the SQL Developer team focuses on providing complete graphical logical and physical data modeling functionality delivered as an independent product Oracle SQL Developer Data Modeler. As an independent product, SQL Developer customers can continue to use the base SQL Developer product with no impact. The base product will continue to benefit from further updates, with new features added gathered from the user community requirements.

Oracle SQL Developer Data Modeler

  • Database Data Modeling to support:
    • Designing logical Entity Relation Diagrams
    • Building physical schema designs
    • Generating and executing DDL scripts
    • Reverse and forward engineering of existing relational data structures
    • Data domain administration
    • Naming standardization
    • Model formatting (font, colors)
    • Importing data models from CA Erwin Data Modeler and Oracle Designer
    • Compare and merge facilities
    • Multiple database support
      • Oracle Database
      • DB2 (Mainframe & UDB)
      • Microsoft SQL Server
    • Logical and physical multi-dimensional modeling
    • Object relational Data Types
    • Spatial Modeling
    • Multi-level logical and physical design environments
    • Model validation rules
    • Offline (file based) based modeling
    • Repository based reporting

Plans for the next release of Oracle SQL Developer include the following:

  • Ongoing updates to current SQL Developer functionality
    • Migration support to include DB2 and Teradata
    • Oracle Database 11g support
    • Tuning support
  • SQL and PL/SQL Unit Testing
    • SQL Testing
    • PL/SQL Testing
    • Repository based
    • Reporting
    • Scheduled tests

THE FOLLOWING IS INTENDED TO OUTLINE OUR GENERAL PRODUCT DIRECTION. IT IS INTENDED FOR INFORMATION PURPOSES ONLY, AND MAY NOT BE INCORPORATED INTO ANY CONTRACT. IT IS NOT A COMMITMENT TO DELIVER ANY MATERIAL, CODE, OR FUNCTIONALITY, AND SHOULD NOT BE RELIED UPON IN MAKING PURCHASING DECISION. THE DEVELOPMENT, RELEASE, AND TIMING OF ANY FEATURES OR FUNCTIONALITY DESCRIBED FOR ORACLE'S PRODUCTS REMAINS AT THE SOLE DISCRETION OF ORACLE.