What You See Is What You Get Element


Oracle SQL Developer 18.1 Release Notes


Date: March 2018

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

 These release notes contain the following:

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

SQL Developer 18.1 offers built-in support for the Autonomous Data Warehouse Cloud Service. SQL Developer offers simple and easy end-to-end migration of AWS Redshift systems to our new Oracle Cloud Service. Other new features and key enhancements for version 18.1 includes, but are not limited to.

  • Enhancements to the Start Page
    • Recent Connections Feature, quick click to connect
    • View TNS entries, browse to specific TNS for new connection
    • Feature screenshots with captions
    • Updated links to tutorials, channels, downloads
    • Shows current version and if an update is available
  • DBA Users Editor – SQL page now generates complete DDL for user including GRANTS
  • SQL injection advisor displays dependency chains
  • Support for SQL Statements in PL/Scope search against Oracle Database 12.2+
  • New Tooltips on search input tree panel for Code category items
  • ORDS 18.1.1 bundled
  • ORDS 18.1.1 Installer support for CDB MIGRATE OPTION
  • Improved Arbori Editor:
    • syntax error highlighting
    • catch syntax errors before Arbori execution
  • Create table dialog partition set and composite hash partition support
  • Sharding Enhancements
    • sharding checkbox to create tablespace dialog for Oracle Database 12.2
    • support 'create table'dialog for 'tablespace set' clause in subpartition template for a sharded table
  •  Change Case as You Type was removed from the Code Insight Preferences page. Use the Code Formatter to set your identifier and keyword preferences, and format your code on demand instead. 
Before You Start

JDK Support

  • Oracle SQL Developer 18.1 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_152.
  • Java versions 9 and 10 are not yet supported.
Platform Support
  • Oracle SQL Developer 18.1 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 Releases.


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