Oracle intros SQL Developer 3.0 for developers, DBA

REDWOOD SHORES, USA: To further ease and improve Oracle Database developer productivity, Oracle has announced the availability of Oracle SQL Developer 3.0.

Based on customer feedback, this new release focuses on ease of migration, improving development and database administrator (DBA) tasks, and introduces support for Oracle Data Mining and Oracle Spatial said a company release.

Also read: Oracle all set to open in Technopark in June

"Leveraging the mass popularity of Oracle SQL Developer, we are releasing our new Oracle Data Miner 11g Release 2," said Cetin Ozbutun, vice president, Data Warehouse, Oracle.

"With Oracle Data Mining, the data, models and predictive analytics never leave the database enabling significantly more functionality, security, performance and scalability at a lower total cost of ownership. In addition, when used with Oracle Exadata, data mining models built with Oracle Data Miner are pushed to storage for execution, providing even better scalability."

Also read: Oracle to stop writing software for Itanium processor

New capabilities extend Oracle SQL developer appeal to broader audience

* Comprehensive and lightweight, Oracle SQL Developer 3.0 introduces new and enhanced usability features that help improve the productivity of DBAs and developers of all experience levels including:

Enterprise Migrations - introduces command line scriptable migrations enabling automation;
Application Scanning - introduces scanning of source code for Sybase ctlib/dblib APIs;
Database Navigator - offers DBAs and developers a simple entry point to browse and update a database, including configuration and storage files, security for profiles, roles and users, and more;
DBMS Scheduler - this new graphical editor helps users create, manage and plan programs, schedules, jobs and a variety of other objects;
SQL Tuning Advisor - this code advisor analyzes high-volume SQL statements and offers tuning recommendations to developers writing queries;
Explain Plan Diff - enables developers to run and compare queries and review Explain Plans side-by-side; and,
Query Builder - offers developers a simple to use drag and drop interface for building queries.

This new release also embeds Oracle SQL Developer Data Modeler 3.0 to enable developers to open, view, and now update designs developed previously as well as query, run and write reports against the reporting repository added the release.  

Oracle SQL Developer is supported through My Oracle Support with any Oracle Database license and runs on Windows, Linux and Mac OS X.