 | |
 | |
| Developer(s) | Oracle Corporation |
|---|---|
| Stable release | 23.1.1.345.2114 (December 15, 2023 [1] ) [±] |
| Written in | Java |
| Platform | Java SE |
| Type | SQL Integrated development environment |
| License | Proprietary [2] |
| Website | www |
Oracle SQL Developer is an Integrated development environment (IDE) for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.
Oracle SQL Developer supports Oracle products. In the past a variety of third-party plugins were supported which users were able to deploy to connect to non-Oracle databases. Oracle SQL Developer worked with IBM Db2, Microsoft Access, Microsoft SQL Server, MySQL, Sybase Adaptive Server, Amazon Redshift and Teradata databases. [3]
Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for PL/SQL.
Future versions of Oracle SQL Developer will use Visual Studio Code. [4]
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 within Oracle SQL Developer. [5]
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: [6]
| Version | Release Date | Description |
|---|---|---|
| Releases prior to 1.0 | Prior to version 1.0, Oracle Corporation labeled the product "Raptor" | |
| 1.0 | March 2006 | The first release |
| 1.1 | December 2006 | |
| 1.2.1 | August 2007 | |
| 1.5 | April 2008 | |
| 1.5.1 | June 2008 | |
| 1.5.3 | December 2008 | |
| 1.5.4 | March 2009 | |
| 1.5.5 | July 2009 | |
| 2.1 RC1 | December 2009 | |
| 2.1 Patch 1 | March 2010 | |
| 3.0 | March 2011 | |
| 3.1 | February 2012 | |
| 3.2 | August 2012 | APEX listener administration; UI enhancements; 12c database support; bug fixes [11] |
| 4.0 | December 2013 | |
| 4.0.1 | February 2014 | |
| 4.0.2 | May 2014 | |
| 4.0.3 | September 2014 | |
| 4.1.1 | June 2015 | |
| 4.1.2 | October 2015 | Requires Java 8 |
| 4.1.3 | December 2015 | |
| 4.1.5 | September 2016 [12] | |
| 4.2.0 | April 2017 [13] | |
| 17.2 | July 2017 [14] | New version numbering system with year.quarter used. [14] |
| 17.4 | Dec 2017 [15] | |
| 18.1 | April 2018 [16] | |
| 18.2 | July 2018 [17] | |
| 18.3 | October 2018 [18] | |
| 18.4 | January 2019 [19] | |
| 19.1 | April 2019 [20] | |
| 19.2 | August 2019 [21] | |
| 19.4 | December 2019 [22] | |
| 20.2 | June 2020 [23] | |
| 20.4 | January 2021 [24] | |
| 20.4.1 | February 2021 [25] | |
| 21.2 | August 2021 [26] | |
| 21.4 | December 2021 [27] | |
| 21.4.2 | January 2022 [28] | |
| 22.2 | June 2022 [29] | Requires Oracle Java 11 |
| 22.2.1 | September 2022 [30] | |
| 23.1 | April 2023 [31] |
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 organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.
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. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.
Oracle Corporation is an American multinational computer technology company headquartered in Austin, Texas, United States. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. In 2023, the company’s seat in Forbes Global 2000 was 80. The company sells database software and cloud computing. Oracle's core application software is a suite of enterprise software products, such as enterprise resource planning (ERP) software, human capital management (HCM) software, customer relationship management (CRM) software, enterprise performance management (EPM) software, Customer Experience Commerce and supply chain management (SCM) software.
Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.
Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.
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 XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.
FileMaker is a cross-platform relational database application developed by Claris International, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to visually modify a database. Versions for desktops, servers, iOS and web-delivery have been released.
Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation.
The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.
SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers.
Toad is a database management toolset from Quest Software for managing relational and non-relational databases using SQL aimed at database developers, database administrators, and data analysts. The Toad toolset runs against Oracle, SQL Server, IBM DB2, SAP and MySQL. A Toad product for data preparation supports many data platforms.
Oracle Spatial and Graph, formerly Oracle Spatial, is a free option component of the Oracle Database. The spatial features in Oracle Spatial and Graph aid users in managing geographic and location-data in a native type within an Oracle database, potentially supporting a wide range of applications — from automated mapping, facilities management, and geographic information systems (AM/FM/GIS), to wireless location services and location-enabled e-business. The graph features in Oracle Spatial and Graph include Oracle Network Data Model (NDM) graphs used in traditional network applications in major transportation, telcos, utilities and energy organizations and RDF semantic graphs used in social networks and social interactions and in linking disparate data sets to address requirements from the research, health sciences, finance, media and intelligence communities.
Oracle Designer was Oracle's CASE tool for designing an information system and generating it. After generating the information system one is able to edit the generated code with Oracle Developer Suite.
Oracle Data Mining (ODM) is an option of Oracle Database Enterprise Edition. It contains several data mining and data analysis algorithms for classification, prediction, regression, associations, feature selection, anomaly detection, feature extraction, and specialized analytics. It provides means for the creation, management and operational deployment of data mining models inside the database environment.
Silverstripe CMS is a free and open source content management system (CMS) and framework for creating and maintaining websites and web applications. It provides an out of the box web-based administration panel that enables users to make modifications to parts of the website, which includes a WYSIWYG website editor. The core of the software is Silverstripe Framework, a PHP Web application framework.
Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, Redis, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.
Toad Data Modeler is a database design tool allowing users to visually create, maintain, and document new or existing database systems, and to deploy changes to data structures across different platforms. It is used to construct logical and physical data models, compare and synchronize models, generate complex SQL/DDL, create and modify scripts, and reverse and forward engineer databases and data warehouse systems. Toad's data modelling software is used for database design, maintenance and documentation.
Oracle WebLogic Server is a Java EE application server currently developed by Oracle Corporation. Oracle acquired WebLogic Server when it purchased BEA Systems in 2008.
Actian Zen is an ACID-compliant, zero-DBA, embedded, nano-footprint, multi-model, Multi-Platform database management system (DBMS) developed originally by Pervasive Software, which was acquired by Actian Corporation in 2013.
Oracle NoSQL Database is a NoSQL-type distributed key-value database from Oracle Corporation. It provides transactional semantics for data manipulation, horizontal scalability, and simple administration and monitoring.
OWA (Oracle Web Agent) or MOD_PLSQL is an Apache (Web Server) extension module.
SQL Developer Data Modeler is a data modeling and database design tool that provides an environment for capturing, modeling, managing, and exploiting metadata.[...] SQL Developer Data Modeler is a for-cost option of SQL Developer that requires a separate license. However, a free viewer (read-only) version is also available [...]
Is Oracle SQL Developer Data Modeler free? - Yes.
When you save a database design, the structural information is stored in an XML file (with the extension .dmd)
| Corporate directors | |
|---|---|
| Acquisitions (list) | |
| Databases | |
| Programming languages | |
| IDEs | |
| Middleware | |
| Operating systems | |
| Computer hardware | |
| Computer appliances | |
| Education and recognition | |
