Oracle SQL Developer New Features in Release 4.1
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 - 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 - 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 - 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 - 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
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 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
This release requires JDK 8. Download it here.
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.