SOURCE: Oracle Corporation

Oracle Corporation

April 14, 2011 08:00 ET

Oracle® SQL Developer 3.0 Enables Improved Database Developer Productivity

Latest Release Features Support for Oracle Data Mining and Oracle Spatial and Upgraded Migration Workbench

REDWOOD SHORES, CA--(Marketwire - Apr 14, 2011) - Oracle (NASDAQ: ORCL)

News Facts

  • To further ease and improve Oracle® Database developer productivity, Oracle today 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.
  • A free graphical tool for database development, Oracle SQL Developer Release 3.0 is downloadable today from the Oracle Technology Network (OTN).

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.
  • 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.
  • The new spatial data management feature provides an SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in Oracle Database 11g enabling users to visualize query results in a map view. In addition, users can display layers on a map depending on the queries executed as well as drag and drop tables onto a map for quick display.
  • Oracle SQL Developer previously introduced an Oracle TimesTen In-Memory Database extension helping developers generate reports, perform group cache operations, manage users, browse and compile PL/SQL packages, procedures and functions, update table and column statistics and create, edit and drop a wider range of database objects.
  • Based on customer feedback, Oracle SQL Developer 3.0 delivers an upgraded migration workbench that improves the developer experience to help customers and partners simplify and reduce the cost of migrating to Oracle Database 11g.
  • To guide migration, developers can run project estimation and server reports, produce data quality metrics, drill into potential conversion issues and then use an interactive wizard that supports all phases of migration.
  • This new release 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.
  • Oracle SQL Developer is supported through My Oracle Support with any Oracle Database license and runs on Windows, Linux and Mac OS X.

Supporting Quotes
"For accessing the Oracle TimesTen In-Memory Database, Oracle SQL Developer 3.0 delivers great enhancements over the previous version by providing a convenient interface for some basic administration tasks like statistics update, adding and removing users, and manipulating cache groups, synonyms, among other features," said Krishnaswamy Balakrishnan, Manager, Database Engineering, Barnes & Noble. "In addition, it's a great tool for developers to test and compile their PL/SQL code."

"Oracle SQL Developer is great for us because it gives us the open API we need to create our own features, and it gives us a great market reach advantage because so many people use it," said Cary Millsap, President, Method R Corporation. "Oracle's standard channel for distributing our extension makes it very easy for our customers and us to do business together."

"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."

Supporting Resources

About Oracle SQL Developer

About Oracle Data Mining

About Oracle Spatial 11g

About Oracle TimesTen In-Memory Database

About Oracle Database 11g

Read Oracle SQL Developer 3.0 Data Sheet

Oracle Expert Blogs: Sue Harper and Kris Rice

Oracle Forum: SQL Developer

Connect with Oracle Database via Blog, Facebook and Twitter

Download Oracle SQL Developer 3.0. Terms, conditions and restrictions apply.

About Oracle
Oracle (NASDAQ: ORCL) is the world's most complete, open, and integrated business software and hardware systems company. For more information about Oracle, please visit our Web site at

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Information

  • Contacts:
    Eloy Ontiveros
    Email Contact

    Kristin Reeves
    Blanc & Otus for Oracle
    Email Contact