Oracle SQL Developer is an

Integrated development environment An integrated development environment (IDE) is a software application that provides comprehensive facilities to computer programmers for software development. An IDE normally consists of at least a source code editor, build automation tools ...

(IDE) for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the

Java Development Kit The Java Development Kit (JDK) is a distribution of Java Technology by Oracle Corporation. It implements the Java Language Specification (JLS) and the Java Virtual Machine Specification (JVMS) and provides the Standard Edition (SE) of the Java ...

Features

Oracle SQL Developer supports Oracle products. In the past a variety of third-party plugins was supported which users were able to deploy to connect to non-Oracle databases. Oracle SQL Developer worked with IBM Db2,

Microsoft Access Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools (not to be confused with the old Microsoft Access ...

Microsoft SQL Server Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which ...

MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database ...

, Sybase ''Adaptive Server'',

Amazon Redshift Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquire ...

and

Teradata Teradata Corporation is an American software company that provides cloud database and analytics-related software, products, and services. The company was formed in 1979 in Brentwood, California, as a collaboration between researchers at Caltech ...

databases. Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for

PL/SQL PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 6 - stored PL/SQL procedures/functions/packages/triggers since ...

Components

Oracle SQL Developer product components include the OWA (Oracle Web Agent or MOD_PLSQL), an extension module for the Apache web server, and helps in setting up dynamic web-pages from

within Oracle SQL Developer.

Extensions

In addition to the extensions provided by Oracle, third parties have written extensions to add new features to SQL Developer and to integrate with other products: ; New features:
GeoRaptor

Geospatial Geographic data and information is defined in the ISO/TC 211 series of standards as data and information having an implicit or explicit association with a location relative to Earth (a geographic location or geographic position). It is also ca ...

data viewer
Insider
Collect statistics for a single Oracle instance and display in real time
Schema Visualizer
allows you to create fully featured Entity Relationship Diagrams (ERD) ; Integration with other Oracle products: * SQL Developer Data Modeler operates with and models metadata. Prior to SQL Developer version 3, it constituted a separate (but integrated) free counterpart of SQL Developer. As of SQL Developer version 3 modeling became an integrated part of the overall tool. "Data Modeler" can produce (among other outputs) files. ;Integration with other commercial products:
Red Gate - Deployment Suite for Oracle
(Compares schemas and data; deploys all changes.)
JDBCWizard
(produces Java Web Service code to run your existing PL/SQL and SQL statements)
Method R Trace
(zero-click trace file collector)
Digger
(trace analyzer)
SVCO Extension
(integrated version-control for Oracle database server schema objects)

History

References

Bibliography

* *

External links

* {{DEFAULTSORT:Oracle Sql Developer Database administration tools SQL clients PL/SQL editors Oracle software Oracle database tools Microsoft database software Sybase 2006 software