Oracle SQL Developer Feature List
Date: September 2013
This document provides a summary listing of features available in Oracle SQL Developer.
Oracle SQL Developer is the Oracle Database Integrated Development Environment (IDE.) A graphical user interface (GUI) alternative or supplement to SQL*Plus and Oracle Enterprise Manager, SQL Developer is used by more than 2,500,000 people around the world and enjoys being one of the most popular resources on the Oracle Technology Network (OTN).Support
Click on version number to access release details.
This feature list covers major features available in the current release, version 4.0.Object Browser || SQL Worksheet || Data Grids || Procedure Editor || Version Control || Reports || DBA Console || Unit Testing || Database Utilities || Data Modeler || APEX Listener Administration || RESTful Services || Database Migrations
SQL Developer allows you to explore the contents of your database using the connection tree. Expanding the tables node will show you the tables for the connected user. A complete list of supported database object types follows.
Browsing the contents outside the current schema can be accomplished by expanding the 'Other Users' tree node or by using the Schema Browser (available on the connection context menu.)
Selected objects will open in an editor allowing the user to view or manipulate it based on their granted privileges.
The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output.Basic SQL Worksheet functionality includes:
The grids present data in a spreadsheet, row:col like interface. These are used throughout the product, but primarily for displaying the contents of tables and the results from executing one or more queries.
Basic SQL Worksheet functionality includes:
The Procedure Editor is a complete IDE for the PL/SQL programming language. Stored Procedures, Functions, Packages, Types, and Triggers can be executed, compiled, refactored and more using the Procedure Editor. Access the Procedure Editor by clicking on a PL/SQL object in the connection tree or by opening a file with a file extension mapped to PL/SQL objects.Basic Procedure Editor functionality includes:
Oracle SQL Developer ships with support for Subversion and Git by default. Users can optionally add support via extensions for CVS and Perforce.
Oracle SQL Developer ships with many pre-defined reports you can run to learn more about the contents, activity, and configuration of your database.
Additionally, users can create their own custom reports, which can also be shared with other users. Said reports can setup to use bind variables (user supplied inputs), be linked to other reports, and can be exported to both HTML and PDF hard copies. PDF reports can be further secured with an optional password.
Reports can take advantage of more than 50 different charting options, making large amounts of data easier to consume and understand. Reports can be setup of one master and optionally one or more children reports.
Reports can also be generated from the command-line interface.
Any existing SQL Developer connection can be added to the DBA panel, available under the View menu. This allows users with administrative privileges to access features across the following areas:Database Configuration
SQL Developer provides a unit testing mechanism for your PL/SQL code. Create and run tests that validate your programs are doing what you say they should be doing.
Unit Tests can be ran directly from the SQL Developer interface or kicked off from your automated build environments using the SQL Developer command-line interface.
Oracle SQL Developer Data Modeler is a separate, stand-alone data modeling solution. It also runs inside of Oracle SQL Developer as an extension. Please consult the the Data Modeler's product page for more details.
Developers can manage, configure, and test multiple Oracle APEX Listener services with SQL Developer's Administration pane. You can quickly create, retrieve, upload, and save APEX Listener settings on demand. This makes for much easier testing and development.
In addition, SQL Developer is able to define all of the APEX Listener's REST abilities, allowing the developer to test queries or PLSQL blocks before publishing them and getting a webserver 500 error with no information as to why. Additionally the user will be able to use a functioning SQL Worksheet to test and tune their REST call queries, e.g. use code insight, EXPLAIN PLANs, Autotrace, the SQL Tuning Advisor, and more.
Oracle SQL Developer is the primary migration platform for Oracle Database. Move your Teradata, DB2, Sybase, SQL Server, MySQL, and Access databases and applications to Oracle with SQL Developer.