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.
History The SQL Developer product was initially created in response to a large invoice sent from Quest Software to Oracle Corporation over the use of Quest's TOAD product within Oracle's consulting group - Quest claimed that Oracle used the tool far more extensively than their license allowed for.
Larry Ellison personally called the lead developer during lunch early in 2006, stating that the payment just made to Quest in response to this (per Oracle's view) unwarranted license charge would be the last time Oracle paid the company for TOAD, and the developer was instructed to build a product that could replace it.This was witnessed personally by the group of Oracle employees that were sitting at the table, including myself.
The initial release of SQL Developer was quickly put together, and released to Oracle internally immediately.
Features 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.
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.
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 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:
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. Data Miner
History + Oracle SQL Developer versions 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 20113.1February 20123.2August 2012 APEX listener administration; UI enhancements; 12c database support; bug fixes4.0December 20134.0.1February 20144.0.2May 20144.0.3September 20144.1.1June 20154.1.2October 2015Requires Java 84.1.3December 20154.1.5September 20164.2.0April 201717.2July 2017 Oracle SQL Developer 17.2 Release NotesNew version numbering system with year.quarter used.17.4Dec 201718.1April 201818.2July 201818.3October 201818.4January 201919.1April 201919.2August 201919.4December 201920.2June 202020.4January 202120.4.1February 202121.2August 202121.4December 202121.4.2January 202222.2June 2022Requires Oracle Java 1122.2.1September 202223.1April 202324.3October 2024Requires Oracle Java 1724.3.1December 202426.2July 2026
See also JDeveloper Oracle Developer Suite
References
Bibliography
External links