Oracle Upgrades Free SQL Developer Tool - InformationWeek
IoT
IoT
Software // Information Management
News
1/11/2007
10:47 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%
RELATED EVENTS
The Real Impact of a Data Security Breach
Aug 02, 2017
In this webcast, experts discuss the real losses associated with a breach, both in the data center ...Read More>>

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 http://sqldeveloper.oracle.com.

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
IT Strategies to Conquer the Cloud
Chances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.
Video
Slideshows
Twitter Feed
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.
Flash Poll