Oracle SQL Developer gets an update
Oracle says its newly updated SQL Developer tool includes enhancements that make it easier to create and debug SQL and PL/SQL code.
In a move designed to give the SQL developer a one-stop-shop for their SQL editing needs, Oracle today unveiled...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
a new version of its free SQL Developer tool.
But one developer who has used both the free SQL Developer tool and its chief competitor, Quest Software Inc.'s popular Toad for Oracle software, says he's opting for the latter, despite the fact that Toad is not free.
"There were some problems with the way that SQL Developer just didn't do things, and it was not conducive to the way I work," said Chris Tryon, manager of programming at Hatch Mott MacDonald, an engineering consulting firm based in Milburn, New Jersey. "Having said that, though, there are people in my group for whom SQL Developer is extremely relevant and useful, and I make sure that those people know about it and use it."
Tryon, who hasn't yet tried the new version of SQL Developer, says he started using the free tool when it first came out last March. He used it extensively for a while until ultimately deciding to go back to Toad. Tryon and the database administrator he works with repeatedly ran into trouble when attempting to use the original version to debug code.
![]() |
||||
|
![]() |
|||
![]() |
"We just couldn't get the [Java Debug Wire Protocol] stuff to work," Tryon said. "I've been a loyal Toad user for a while now."
New features and functionality
Oracle SQL Developer Release 1.1 offers new features that make it easier for developers to create and debug SQL and PL/SQL code, including a redesigned extensible object browser with newly added filtering capabilities, expanded SQL Plus compatibility, and improved Data Grid features, according to Oracle.
Built on the Oracle Fusion Client Platform (also known as the Oracle JDeveloper IDE), SQL Developer 1.1 lets users browse non-Oracle database management systems, including Microsoft's SQL Server, open source MySQL and Microsoft Access. Users can import and export data from a variety of formats, including spreadsheets. Oracle says that SQL Developer 1.1 also lets users build detailed reports that can include charts.
Oracle SQL Developer is available as a free download from the