What is SQL Developer?
Date: Mar 2010
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 10g and later and runs on Windows, Linux and Mac OSX.
SQL Developer supports migrating 3rd party databases to Oracle. The tight integration capabilities provide 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 provides PL/SQL Unit Testing, integrated Data Modeler Viewer and integrated support for versioning and the source control systems Subversion, CVS (Concurrent Versions System), Serena Dimensions and Perforce. 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, release 2.1 includes many updated features, such as SQL Formatting, Schema Compare, Copy and Export wizards and the addition of migration support for IBM DB2 and Teradata. Times Ten support is also integrated with the product. A listing of all the new SQL Developer 2.1 functionality is available.
Download Oracle SQL Developer 2.1, released in Dec 2009, from OTN.
Below is a summary of the capabilities of SQL Developer. Click on the image thumbnail to view a full-sized image.
SQL Developer fully support connections to Oracle 10g and above.
Users can create Database Connections for non-Oracle databases MySQL, Microsoft SQL Server, Microsoft Access, Sybase, Teradata and IBM DB2 for object and data browsing. Limited worksheet capabilities also available for these databases.
Objects are grouped together by type. For each object type, a filter can be applied to restrict the display.
On table creation users can specify sequences and before-insert triggers for populating a column with values.
Most objects have a general edit dialog as well as specific modifications available by invoking a context menu through right-clicking.
Use the Query Builder to quickly create SQL queries by drag and drop, to select tables, and mouse-click to select columns.
Data export available from any data grid. This include Table > Data, SQL Worksheet Results and Report output.
Any files opened will be opened into a SQL Worksheet. The user will simply select the appropriate connection from the upper-right list and can edit, execute and save.
Any .pks, .pkb and .pls files opened will be opened into a PL/SQL Code Editor. Uses can edit, use snippets, compile and save these files.
Most of the provided reports include click-through. If a user clicks on a resulting row, the definition of the object in that row is displayed. The SQL for any report can also be pulled into a Worksheet, edited and then stored as your own custom report.
SQL Developer leverages the JDeveloper IDE. This gives developers the option to write extensions.