Hodentek: Vastly improved Oracle SQL Developer Tool 4.0

Friday, July 04, 2014

Vastly improved Oracle SQL Developer Tool 4.0

This is a great tool if you are working with Oracle and you can do all of this:
Develop
Administer
Model
Migrate

I have been using SQL Developer tool since 2007 and I find the latest version released this may vastly improved with a rich interface.

The latest release 4.0 can be downloaded from here:
Oracle SQL Developer 4.0.2 (4.0.2.15.21)
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

The x64 bit version I downloaded came with the required JDK (7.0).

Apart from these new features SQL Developer 4.0 it supports Oracle database 12C:

Database performance monitoring'
Database search
Command line support now covers reporting and Cart
Cart itself has enhanced features-multiple cart support; export ddl options, etc.
Creating and drill -down on Reports with floating Editor and Navigation windows
UI enhancements- Usability enhancements
Data modeler is now 4.0 to support 12C with masking of sensitive data and ability to create Trasparent Sensitive Data Protection
Oracle Migrations
Oracle Data Miner

Installation cannot be easier than this. Download the zip file (Choose the one that you can work
with), unzip and start using.

While installing you may import your preferances from an earlier version if it exists. The
computer I am using did not have any previous installation.

The User Interface gets displayed as shown with a modal window requesting your permission
to track usage for product improvement. I generally say, OK.

The View menu shows many of the features that you will be using.

Team menu lets you connect to GIT or to Subversion

The Start page also has important informative content such as Videos; Tutorials and Online demonstrations, etc

The Tools menu is also feature rich as it gives you access to many of tasks you may need to perform and the Data Modeler submenu shown above shows many features of database administration'