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
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 ...
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 Visualizerallows 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
See also
*
JDeveloper
JDeveloper is a freeware IDE supplied by Oracle Corporation. It offers features for development in Java, XML, SQL and PL/SQL, HTML, JavaScript, BPEL and PHP. JDeveloper covers the full development lifecycle from design through coding, debuggi ...
*
Oracle Developer Suite
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