No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions

Oracle SQL Developer 20.2 Release Notes

June 2020

SQL Developer | Downloads | Documentation | Exchange | Forum

Feature Enhancements

  • Debugger - option to use DBMS_DEBUG for database debugging
  • Load options include SET LOADFORMAT and SET LOADMETHOD for more flexibility on loading table data
  • ORDS installer supports:
    • REST SQL and SQL Developer Web configuration
    • Custom JDBC urls and TNS
    • Allows non-SYSDBA user to install/upgrade, repair and uninstall ORDS
  • SQLcl Liquibase new commands: ROLLBACKSQL, DIFF, DBDOC, VERSION
  • Liquibase changeSet IDs are now generated as a hash of the content
  • Explain Plan/Autotrace Search
  • Include Orakafka ZIP in all distributions
  • Java Home updated to 8u221
  • Oracle NoSQL plugin updated to version 19.3.12
  • Database Copy added 'Ignore Storage' to avoid tablespace dependencies
  • SQL Editor Code template options panel moved to code editor page
  • Code formatter new setting for number of commas to allow before a linebreak on PL/SQL call
  • Added SET CODESCAN to look for SQL Injection vulnerabilities
  • TABLE IMPORT enhanced to ignore virtual columns
Before You Start

JDK Support

  • Oracle SQL Developer 20.2 release requires Oracle Java 8 or 11, with a minimum version of 1.8 update 171. 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.
  • The Data Miner and SVN client features require Java 8
  • Saving your connection passwords requires at least Oracle JDK 8u152 (for access to JCE jars)

Platform Support

  • Oracle SQL Developer 20.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

Extension

Many of the features in SQL Developer are provided by other Oracle Database teams. Please use their respective Oracle Community Forums 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