Oracle SQL Developer
Template:Short description Script error: No such module "Infobox".Template:Template other Script error: No such module "Check for unknown parameters".Script error: No such module "Check for conflicting parameters". 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.
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.[1]
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.[2]
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.[3]
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:[4]
- Integration with other Oracle products
- SQL Developer Data Modeler operates with and models metadata.[5] Prior to SQL Developer version 3, it constituted a separate (but integrated) free[6] 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) Template:Mono files.[7]
- Data Miner[8]
History
| 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[10] |
| 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[11] | |
| 4.2.0 | April 2017[12] | |
| 17.2 | July 2017[13] | New version numbering system with year.quarter used.[13] |
| 17.4 | Dec 2017[14] | |
| 18.1 | April 2018[15] | |
| 18.2 | July 2018[16] | |
| 18.3 | October 2018[17] | |
| 18.4 | January 2019[18] | |
| 19.1 | April 2019[19] | |
| 19.2 | August 2019[20] | |
| 19.4 | December 2019[21] | |
| 20.2 | June 2020[22] | |
| 20.4 | January 2021[23] | |
| 20.4.1 | February 2021[24] | |
| 21.2 | August 2021[25] | |
| 21.4 | December 2021[26] | |
| 21.4.2 | January 2022[27] | |
| 22.2 | June 2022[28] | Requires Oracle Java 11 |
| 22.2.1 | September 2022[29] | |
| 23.1 | April 2023[30] | |
| 24.3 | October 2024[31] | Requires Oracle Java 17 |
| 24.3.1 | December 2024[32] |
See also
References
<templatestyles src="Reflist/styles.css" />
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ a b [1] Oracle SQL Developer 17.2 Release Notes
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
- ↑ Script error: No such module "citation/CS1".
Script error: No such module "Check for unknown parameters".
Bibliography
<templatestyles src="Refbegin/styles.css" />
- Script error: No such module "citation/CS1".
- Script error: No such module "citation/CS1".
External links
- Script error: No such module "Official website".Script error: No such module "Check for unknown parameters".
Script error: No such module "Navbox".