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 New Features in Release 4.1

Copy Database to Oracle Database Cloud Service

Copy Database to Oracle Database Cloud Service

SQL Developer's DBA panel allows an administrator connected to a 12c Database with a Multi-tenant architecture database to select a pluggable database, and copy or move it up to their Oracle Database Cloud Service environment. SQL Developer will unplug the database, copy it up to the Cloud Service, and plug it in seamlessly with no interaction required from the administrator. The progress of the entire process and the uploading of the files can be monitored within SQL Developer itself.

Import Data Wizard

Import Data Wizard - Watch Video

One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command.

Instance Viewer

Instance Viewer - Watch Video

Visualize the status of your database in a brand new, graphical representation of the IO, wait events, storage, log switches, and processes. Requiring no server side objects, agents, or database changes, this new SQL Developer feature will shorten the amount of time it takes to diagnose ongoing performance issues. From the main page, DBAs and power users can quickly drill down into various activity reports to see the details

General Enhancments

General Enhancments - Watch Video

By popular demand, SQL Developer now offers multi-cursor editing, remembering frequently used files and directories in open and save file dialogs, and verbose SQL recording for all statements sent to the database.

Automatic REST Enablement of Tables

Automatic REST Enablement of Tables - Watch Video

Provided that an Oracle REST Data Services (ORDS) v3.0 service is available, developers will be able to select one or more tables in the SQL Developer connection tree and have REST endpoints automatically deployed to allow for easy selects and updates available via industry standard REST GET and POST calls.

NoSQL Support

NoSQL Support

SQL Developer now supports Oracle NoSQL database. Support includes Developer and DBA roles, KVLite Store deployment and seeding, Store Reporting, Store Statistics and Administration.

Data Modeler 4.1

Data Modeler 4.1

Data Modeler 4.1 Beta is now available. This version is also available in SQL Developer 4.1. New features include a new tab in SQL Developer to instantly view the model, enhancements to the Logical and Relational Models, Improved Search, Extended support for objects in Oracle Physical Models and much more.

JDK 8 Support

JDK 8 Support

This release requires JDK 8. Download it here.

JSON Query Node

JSON Query Node

SQLDev/Oracle Data Miner 4.1 added a new JSON Query node that allows users to query JSON data as relational format. In additional, the current Data Source node and Create Table node are enhanced to allow users to specify JSON data in the input data source either from a Database table/view or an External Table that has been mapped to the Oracle Big Data Appliance.