What You See Is What You Get Element


Oracle SQL Developer 4.2 Release Notes


Date: April 2017

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

 These release notes contain the following:

  1. New Features
  2. Before You Start
  3. FAQ
  4. Support
  5. Feedback
New Features

New features and key enhancements for version 4.2 of Oracle SQL Developer includes, but are not limited to. More features can be found here.

  • 12c Release 2 support for:
    • Longer Identifiers
    • Analytic Views
    • Application Containers
    • New SQL Syntax
  • Drag and drop database objects or nodes from one connection to another to copy them
  • Updated Real Time SQL Monitoring viewer
  • Instance Viewer with a Top SQL report
  • Enhancements to SQL and PL/SQL Formatter
  • Various editor improvements including AutoReplace and block editing
Before You Start

JDK Support

  • Oracle SQL Developer 4.2 release requires Java version 1.8 or above. Go here to download the latest version.
  • 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.8.0_60.
Platform Support
  • Oracle SQL Developer 4.2 is available for Windows 7,8,10 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification)
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.
Support & Feedback
  • Early Adopter Releases - support is limted to the Oracle Technology Network Space for SQL Developer. Please post your questions and feedback there. My Oracle Support does not support Early Adopter v


Many of the features in SQL Developer are provided by other Oracle Database teams. Please use their respective OTN Community Spaces to provide feedback..

  • 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