What You See Is What You Get Element


Oracle SQL Developer 18.2 Release Notes


Date: July 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

New features and key enhancements for version 18.2 includes, but are not limited to.

  • Query Builder Enhancements
    • Simple query takes 13.29 seconds to render in Query Builder from worksheet in 18.1
      • Add preference to skip detailed meta data load
        • This disables 'smart' link creation on the diagram
        • Renders orders of magnitude faster (e.g., 19s vs 0.8s)
  • Can now convert Oracle to ANSI Joins wit context menu
  • DBMS_XPLAN Added to Explain Drop Down toolbar menus
  • Automous DataWarehouse Cloud Service TNS entries are now sorted
  • Connection type "cloud pdb" no longer requires keystore password
  • Updated the wallet and oraclepki jars to the versions
  • Code Insight, better support for PL/SQL, Format procedure arguments & Add closing paren& semicolon.
  • Formatter: New Basic Preference: Convert Case Only
  • Enhanced DB Search for dependencies and selected object types
  • Drag and Drop text from a grid will now give you quoted strings
    • intended to aid with WHERE IN ('x', 'y', 'z', ...) lists
    • this happens for ALL grids, including DESC popup dialogs for tables and the columns page.
      • If you are dragging and dropping column names, you will need to use search and replace to remove the single quotes
      • you can also drag and drop columns from the tree or use Code Insight, or 'copy selected column headers' features to get your SELECT columns list without quotes 
  • ORDS 18.2 bundled
  • Exchange: Extract variable/function prototype
  • Exchange: Refactor SQL Query: Convert derived table to CTE or View
  • Exchange: Allow explain/autotrace on selected text
Before You Start

JDK Support

  • Oracle SQL Developer 18.2 release requires Oracle Java 8 or 9, with a minimum version of 1.8 update 121. 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 10 and higher are not yet supported and will not work.
  • Users with high DPI displays may have rendering issues with Java 9, and are encouraged to run Java 8.
  • The Data Miner and SVN client features require Java 8, and will not work with Java 9.
Platform Support
  • Oracle SQL Developer 18.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 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