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.

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) .dmd files.
  • Data Miner

History

Oracle SQL Developer versions
VersionRelease dateDescription
Releases prior to 1.0Prior to version 1.0, Oracle Corporation labeled the product "Raptor"
1.0March 2006The first release
1.1December 2006
1.2.1August 2007
1.5April 2008
1.5.1June 2008
1.5.3December 2008
1.5.4March 2009
1.5.5July 2009
2.1 RC1December 2009
2.1 Patch 1March 2010
3.0March 2011
3.1February 2012
3.2August 2012APEX listener administration; UI enhancements; 12c database support; bug fixes
4.0December 2013
4.0.1February 2014
4.0.2May 2014
4.0.3September 2014
4.1.1June 2015
4.1.2October 2015Requires Java 8
4.1.3December 2015
4.1.5September 2016
4.2.0April 2017
17.2July 2017New version numbering system with year.quarter used.
17.4Dec 2017
18.1April 2018
18.2July 2018
18.3October 2018
18.4January 2019
19.1April 2019
19.2August 2019
19.4December 2019
20.2June 2020
20.4January 2021
20.4.1February 2021
21.2August 2021
21.4December 2021
21.4.2January 2022
22.2June 2022Requires Oracle Java 11
22.2.1September 2022
23.1April 2023
24.3October 2024Requires Oracle Java 17
24.3.1December 2024

See also

Bibliography

  • Harper, Sue (October 20, 2009), (1st ed.), Packt Publishing, p. 496, ISBN 978-1-84719-626-2[permanent dead link]
  • Hotka, Dan (October 10, 2006), (1st ed.), McGraw-Hill, p. 230, ISBN 0-07-148474-4

External links