What is SQL Developer?
Date: May 2014
Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer's main objective is to help the end user save time and maximize the return on investment in the Oracle Database technology stack.
SQL Developer supports Oracle Database 10g, 11g, and 12c and will run on any operating system that supports Java.
SQL Develper isn't just for developers! Since version 3.0, the DBA Panel (available under the View menu) has provided database administrators a set of interfaces for their most critical tasks. SQL Developer will continue to add and enhance features for the DBA. Today, SQL Developer's DBA panel provides support for:
For the Application Architect & Data Modeler
Oracle SQL Developer includes a complete data modeling solution with Oracle SQL Developer Data Modeler (SDDM) running inside the application (also available as a standalone and free installation.) SDDM supports:
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.
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.
Discuss this in the OTN Oracle SQL Developer Forum.
Discuss Migration Workbench issues on theOTN Oracle Migration Workbench Forum.