|
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
|
| |
