Software // Information Management
10:47 PM
Connect Directly

Oracle Upgrades Free SQL Developer Tool

SQL Developer can now import and export data from spreadsheets and other sources, saving tedious re-entry of data.

Oracle recently issued the first upgrade to its free SQL Developer tool, a step it hopes will win further adherents to its easiest-to-use tool. Last March, Oracle supplemented its command line tools with the new offering to introduce a more graphical environment for developing Oracle applications.

SQL Developer can now import and export data from spreadsheets and other sources, saving tedious re-entry of data.

It can browse the tables and data of non-Oracle databases, primarily SQL Server and the open source MySQL at this time. It can inspect a record in a database with "a pivot view" that shows all the elements of the record. Oracle will add an ability to browse its Times Ten in-memory database next, says Michael Hichwa, VP of software development.

The visual environment of SQL Developer has been enhanced with an object browser to show the properties of objects that a developer may be working with. The ability to see the data sets, network connections, and procedural properties of objects helps developers quickly find and work with the ones they want. SQL Developer filtering has been refined to make it easier to discriminate among those objects that may closely resemble each other, Hichwa says.

The tool allows developers to produce either SQL or Oracle's PL/SQL procedures inside or outside the Oracle database system. Developers told Oracle they wanted to be able to produce stored procedures outside the database so they could make use of their version control systems, a way to track the progress of code through several iterations, he says. Previously, SQL Developer assumed developers would want to produce code inside the database system.

Oracle has also created the SQL Developer Exchange, a site where developers can request enhancements to the tool, rate planned feature additions, and share code with other members of the community. The site will also serve as a way to dispense news and blogs about the tool. It is available at

Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest - August 20, 2014
CIOs need people who know the ins and outs of cloud software stacks and security, and, most of all, can break through cultural resistance.
Flash Poll
Twitter Feed
InformationWeek Radio
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.