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 an ...

(IDE) for working with SQL in

Oracle database Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online t ...

Oracle Corporation Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells da ...

provides this product

free Free may refer to: Concept * Freedom, having the ability to do something, without having to obey anyone/anything * Freethought, a position that beliefs should be formed only on the basis of logic, reason, and empiricism * Emancipate, to procur ...

; 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 Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and ...

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 w ...

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 or ...

Sybase Sybase, Inc. was an enterprise software and services company. The company produced software to manage and analyze information in relational databases, with facilities located in California and Massachusetts. Sybase was acquired by SAP in 2010; ...

''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 acquired ...

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 a ...

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 sinc ...

Components

Oracle SQL Developer product components include the OWA (Oracle Web Agent or MOD_PLSQL), an extension module for the

Apache web server The Apache HTTP Server ( ) is a free and open-source cross-platform web server software, released under the terms of Apache License 2.0. Apache is developed and maintained by an open community of developers under the auspices of the Apache Soft ...

, 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 call ...

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