Oracle SQL Developer gets an update

By Mark Brunelli, News Editor 08 Jan 2007 | SearchOracle.com

Oracle tips, scripts, and expert advice Digg This!     StumbleUpon     Del.icio.us

In a move designed to give the SQL developer a one-stop-shop for their SQL editing needs, Oracle today unveiled 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.

More SQL Developer news: Oracle SQL Developer vs. Toad for Oracle: Users speak out, part two

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

Also, Oracle today unveiled the SQL Developer Exchange site, where SQL Developer users can request and rate feature enhancements and share code snippets for building extensions and reports. The site also links to development team blogs, product news and updates.

"We are actually asking users to publish requests and have other users vote on those requests," said Sue Harper, Oracle's senior principal product manager.

The new features Oracle added to SQL Developer represent a direct response to requests from end users, according to Harper. For example, she said, some users found it difficult to use the original version of SQL Developer to query the database, and many were forced to do so using SQL Plus and a command line interface. The feedback led Oracle to include a graphical query builder in 1.1.

"This is great for users trying to build SQL and PL/SQL queries," Harper said. "They use a mouse to drag and drop tables onto a space, and by the click of a mouse they can join different tables together, and the SQL query is created for them."

Users also told Oracle that they didn't like the fact that they had to work with PL/SQL directly in the database, so Oracle added file-based editing capabilities in SQL Developer 1.1.

"With 1.1, users can now access these files from their version control systems," Harper said. "They open them up in SQL Developer, and then they can edit those files and return them to their version control system."

Availability

Oracle SQL Developer is available as a free download from the Oracle Technology Network and runs on Linux, Mac OS X and Windows platforms. Oracle offers SQL Developer support for any customer with an active Oracle Database License. SQL Developer works with all releases of Oracle Database 10g and is also available for Oracle 9i Database Release 2.

Tags: Oracle and SQL,  Oracle stored procedures,  Using Oracle PL/SQL,  VIEW ALL TAGS

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle and SQL Can I specify Oracle column order in my database table? Review: Oracle's 11g R2 database has some good and bad SELECT statement syntax and examples Oracle PL/SQL tutorial PL/SQL datatypes in Oracle PL/SQL functions and triggers in Oracle Stored procedures in PL/SQL Do I need a license for SQL Developer Data Modeler in Oracle? Using the SQL GROUP BY clause for counting combinations How to use an SQL CASE expression Oracle and SQL Research Oracle stored procedures Stored procedure to autotransfer data between Oracle servers Insufficient privileges error when creating stored procedure ORA-01422 error when procedure returns more than one row Calling procedure inside another procedure in anonymous block Can I make a second connection to Oracle without losing the first? How to create an index using a procedure in Oracle Oracle updates Microsoft developer tools Procedure compiles but does not execute Tool in Oracle 10g to keep track of execution of queries ORA-04082: NEW or OLD references not allowed in table level triggers Using Oracle PL/SQL SELECT statement syntax and examples Oracle PL/SQL tutorial PL/SQL datatypes in Oracle PL/SQL functions and triggers in Oracle Stored procedures in PL/SQL How to concatenate rows into a single CLOB in PL/SQL Working with substitution variables and using EXECUTE IMMEDIATE in PL/SQL How to open a ref cursor in a PL/SQL procedure Oracle's free SQL Developer adds database migration tool Confused about Oracle certification exams

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary autonomous transaction  (SearchOracle.com) CFML  (SearchOracle.com) dynamic SQL  (SearchOracle.com) foreign key  (SearchOracle.com) Java Database Connectivity  (SearchOracle.com) Open Database Connectivity  (SearchOracle.com) Oracle  (SearchOracle.com) stored procedure  (SearchOracle.com) The Open Group  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary