Channels ▼


Oracle SQL Developer 3.0 Launched

In a product announcement bid aimed at improving Oracle Database developer productivity, the company has this week announced the availability of Oracle SQL Developer 3.0. This graphical tool for database development has been augmented with new migration functionalities designed to appeal to development and database administrator (DBA) tasks. It also introduces support for Oracle Data Mining and Oracle Spatial -- a tool to manage all geospatial data including vector and raster data, topology, and network models.

The company says that for developers looking to access the Oracle TimesTen In-Memory Database, Oracle SQL Developer 3.0 delivers enhancements over the previous version by providing a convenient interface for some basic administration tasks like statistics updates, adding and removing users, and manipulating cache groups, among other features.

The new Oracle Data Miner extension for Oracle SQL Developer 3.0 is a workflow-based graphical user interface for data mining that enables data analysts to build and evaluate multiple data mining models, apply models to new data, and enable predictive insights across the enterprise.

"Leveraging the popularity of Oracle SQL Developer, we are releasing our new Oracle Data Miner 11g Release 2," said Cetin Ozbutun, VP of data warehousing at 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."

Oracle SQL Developer 3.0's new features include:

  • 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.
  • 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.
  • Query Builder -- offers developers a simple-to-use drag and drop interface for building queries.

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

Related Reading

More Insights

Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.