What You See Is What You Get Element

Oracle SQL Developer 4.0.x Release Notes


Date: September 2014

SQL Developer on OTN | New Features | Downloads | Documentation | Exchange | Forum


These release notes contain the following:

  1. New Features in SQL Developer 4.0
  2. Before You Start
  3. FAQ
  4. Support
  5. Feedback
Before You Start
  • What's New in 4.0.3
    • Big Data Appliance - Added support for importing Hive definitions and generating SQL to define tables that provide access to data in HDFS/Hive.
  • Migrating Passwords
    • Passwords are migrated when installing a new version on the same machine. When porting SQL Developer to a new machine, passwords will not be migrated
  • Third Party Extensions
    • Third Party Extensions written for previous versions of SQL Developer will not work in version 4.0 until Third Party vendor updates extension for OSGI framework. Instructions can be found here
  • JDK Support
    • Oracle SQL Developer 4.0 release supports java version 1.7 and above
    • If SQL Developer cannot find a local JDK, you will be prompted to enter the location path for the JDK. Note that the prompt wants only the folder, not the java.exe.  For example C:\Program Files\Java\jdk1.7.0_25
  • Platform Support
    • Oracle SQL Developer 4.0 is available for Windows XP , Vista, Windows 7 and 8 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification)
  • Version Control
    • Subversion and GIT are installed by default with SQL Developer 4.0. To install CVS, Perforce and Serena Dimensions, please use Help > Check for Updates
  • JDBC Drivers
    • The JDBC drivers shipped are Oracle Database 11g Release 2. To use JDBC Thick Driver, you need to install an 11g Release 2 client
  • Installing or Upgrading
    • All new releases of SQL Developer require a full installation. Download and unzip the file into an empty folder. Ensure the "Use folder names" checkbox is checked when unzipping the file
  • TimesTen and In-Memory Database Cache
    • Support for TimesTen In-Memory Database includes support for Oracle In-Memory Database Cache and TimesTen In-Memory Database Release and later
    • You will not see the TimesTen Connection node unless you have TimesTen installed and configured. More detail on TimesTen can be found on OTN and the TimesTen Release Notes
  • Data Miner
  • OLAP
    • The OLAP extension enables you to use the familiar environment of SQL Developer to create and manage dimensional objects in Oracle Database 12c Release 1 ( or higher. Oracle OLAP provides advanced multidimensional analytic capabilities and storage within the database, including excellent query performance, fast incremental data updates, efficient management of summary data, and rich analytic content, such as time series calculations and both additive and nonadditive aggregations.
  • Production Releases - you are supported by Oracle Support under your current database Support license for SQL Developer production releases. Log SQL Developer bugs and issues using My Oracle Support for the product.


There are a number of different forums supporting the features in SQL Developer. When using the forums, be sure to use clear subject lines to initiate a thread and try to avoid using old, unrelated threads for a new issue.

  • For all SQL Developer queries, please use the SQL Developer forum and use the Oracle SQL Developer Exchange for any feature requests.
  • For all Data Mining related queries, please use the Data Mining forum
  • For all TimesTen related queries, please use the TimesTen forum
  • For all OLAP related queries, please use the OLAP forum
  • For all Data Modeler related queries, please use the Data Modeler forum
  • For all Database Migration related queries, please use the Migrations forum