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 Developer provides powerful editors for working with SQL, PL/SQL, Stored Java Procedures, and XML. Run queries, generate execution plans, export data to the desired format (XML, Excel, HTML, PDF, etc.), execute, debug, test, and document your database programs, and much more with SQL Developer.
For the DBASQL 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:
- Data Pump
- Recovery Manager (RMAN)
- Oracle Auditing
- User and Role
- Storage management, including the ability to add space to your tablespaces
- Resource Manager
- Diagnostic Pack features:
For the Application Architect & Data ModelerOracle 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:
- Logical, relational, physical, dimensional modeling
- Data Flow Diagrams
- DDL scripting
- Importing from data dictionaries, DDL scripts, Oracle Designer Repositories, and ERwin
- a Reporting Repository
- Versioning of your designs via Subversion
- Comparing models with generation of ALTER scripts
- a powerful search and reporting utility
For the Web Application Developer and Administrator Oracle SQL Developer allows you to administer Oracle Rest Data Services and for creating and altering your RESTful services.
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.