Oracle SQL Developer

Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

SQL Developer can connect to any Oracle Database version 9.2.0.1 and later and runs on Windows, Linux and Mac OSX.

SQL Developer includes the Migration Workbench, redeveloped and integrated to extend the functionality and usability offered by the original Oracle Migration Workbench. Its tight integration with SQL Developer provides users with a single point to browse database objects and data in third party databases, and to migrate from these databases to Oracle.

Oracle SQL Developer integrates with Oracle APEX, allowing you to browse applications and perform other Application Express activities. With Oracle SQL Developer you can browse, export and import, drop or deploy applications. There are a selection of Application Express reports and you can create your own custom reports.

The latest release of Oracle SQL Developer includes provides integrated support for versioning and the source control systems CVS (Concurrent Versions System) and Subversion. Supporting the version control is a File Browser to browse and read files stored in the file system. You can open and edit these files from within SQL Developer. In addition to these main additions to SQL Developer, release 1.5 includes many updated features, such as SQL Formatting, Schema Compare, Copy and Export wizards and the addition of migration support for Sybase. Times Ten support is also integrated with the product. A listing of all the new SQL Developer 1.5 functionality is available.

Download Oracle SQL Developer 1.5, released in April 2008, from OTN.

Below is a summary of the capabilities of SQL Developer. Click on the image thumbnail to view a full-sized image.