Oracle SQL Developer Feature List

 

Date: September 2013

This document provides a summary listing of features available in Oracle SQL Developer.
 Jump to the Features List


About

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
  • Download from OTN, also included with Oracle Database Install
  • Free, included with your Database license
  • Support available through MOS for customers with current Database Support contracts
  • Ask questions on the OTN Forums
Major Release History

Click on version number to access release details.

  • 1.1 - December 2006
  • 1.2 - June 2007
  • 1.5 - April 2008
  • 2.1 - December 2009
  • 3.0 - February 2011
  • 3.2 - November 2011
  • 4.0 - Coming Soon

 

Core Features

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

Object Browser

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.

  • Tables
  • Views
  • Editioning Views
  • Indexes
  • Packages
  • Procedures
  • Functions
  • Queues
  • Queue Tables
  • Triggers
  • Crossedition Triggers
  • Types
  • Sequences
  • Materialized Views
  • Materialized View Logs
  • Synonyms
  • Public Synonyms
  • Database Links
  • Public Database Links
  • Tables
  • Directories
  • Editions
  • Application Express
  • Java
  • XML Schemas
  • XML DB Repository
  • Analytic Workspaces
  • Scheduler (DBMS_SCHEDULER & DBMS_JOBS)
  • Recycle Bin

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.

SQL Worksheet

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:
  • SQL statement and script execution recall
  • SQL formatting
  • Explain Plan
  • Autotrace
  • SQL Tuning Advisor - Requires Tuning Pack License
  • Code Intellisense - Type Ahead - Completion
  • Visual Query Builder
  • Integrated File History and Change Logging

Data Grids

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:

  • Single Record View
  • Export to popular formats including:
    • Excel
    • Text
    • HTML
    • Delimited
    • SQL*Loader
    • Insert statements
  • Advanced data type viewers for BLOBs, XML, Dates, etc.
  • Filtering and multi-column sorting
  • Custom display for NULL values
  • Search and highlight

Procedure Editor

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:
  • Compile
  • Compile with Debug
  • Error message feedback and linking to offending source
  • Execute
  • Automatic Capture of Execution Output including Ref Cursors
  • Debug
  • Remote Debug
  • Hierarchical Profiling
  • Documentation via DB Doc
  • Code Templates

Version Control

Oracle SQL Developer ships with support for Subversion and Git by default. Users can optionally add support via extensions for CVS and Perforce.

Reports

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.

DBA Console

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
  • Init Parameters
  • Automatic Undo Management
  • Restore Points
  • Database Feature Usage Reports
Data Pump
  • Wizards for Creating Data Pump Export and Imports
  • Manage existing Export and Import Jobs
RMAN
  • Backup Jobs
  • Backup Sets
  • Image Copies
  • RMAN Settings
  • Scheduled RMAN Jobs
  • RMAN Backup/Restore Wizard
Resource Manager
  • Consumer Groups and Mappings
  • Plans
  • Settings
  • Statistics
Security
  • Audit Settings
  • Profiles
  • Users
  • Roles
Storage
  • Archive Logs
  • Control Files
  • Datafiles
  • Redo Log Groups
  • Rollback Segments
  • Tablespaces
  • Temporary Tablespace Groups

Unit Testing

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.

Database Utilities

From the Tools menu, users can access several powerful and wizard-driven mechanisms for performing routine database tasks, including:
  • Database Copy - copy one or more objects to another database
  • Database Diff - compare objects across schemas or databases and generate ALTER scripts and reports
  • Database Export - export one or more objects to Excel, CSV, etc.
  • Database Import - available from Tables node or table context menu, import data from Excel, text, etc. directly to existing or new table
  • Monitor Sessions - manage database sessions, i.e. kill, trace, and browse
  • Monitor SQL - an interface to the Real Time SQL Monitoring feature, requires the Tuning Pack

Data Modeler

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.

Oracle APEX Listener Administration

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.

RESTful Services

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 Database Migrations

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.

  • Connect, query, and browse 3rd party databases
  • Wizard Driven Interface
  • Project Management and Reports
  • Map datatypes between systems
  • Translate your stored procedures and SQL statements to Oracle
  • Deploy Oracle Database 12c SQL Translation Framework Translators and manage your Translation Profiles
  • Scan your application source code for SQL that requires translation