Oracle SQL Developer
From Wikipedia, the free encyclopedia
Free SQL IDE from Oracle Corporation
| Developer(s) | Oracle Corporation |
|---|---|
| Initial release | 2005; 20 years ago (2005)[1] |
| Stable release | 24.3.0.284.2209 (October 17, 2024; 5 months ago (2024年10月17日)[2] ) [±] |
| Written in | Java |
| Platform | Java SE |
| Type | SQL Integrated development environment |
| License | Proprietary [3] |
| 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.
Features
[edit ]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.[4]
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.[1]
Components
[edit ]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]
Extensions
[edit ]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]
- Integration with other Oracle products
- SQL Developer Data Modeler operates with and models metadata.[7] Prior to SQL Developer version 3, it constituted a separate (but integrated) free[8] 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.[9]
- Data Miner[10]
History
[edit ]| 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[12] |
| 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[13] | |
| 4.2.0 | April 2017[14] | |
| 17.2 | July 2017[15] | New version numbering system with year.quarter used.[15] |
| 17.4 | Dec 2017[16] | |
| 18.1 | April 2018[17] | |
| 18.2 | July 2018[18] | |
| 18.3 | October 2018[19] | |
| 18.4 | January 2019[20] | |
| 19.1 | April 2019[21] | |
| 19.2 | August 2019[22] | |
| 19.4 | December 2019[23] | |
| 20.2 | June 2020[24] | |
| 20.4 | January 2021[25] | |
| 20.4.1 | February 2021[26] | |
| 21.2 | August 2021[27] | |
| 21.4 | December 2021[28] | |
| 21.4.2 | January 2022[29] | |
| 22.2 | June 2022[30] | Requires Oracle Java 11 |
| 22.2.1 | September 2022[31] | |
| 23.1 | April 2023[32] | |
| 24.3 | October 2024[33] | Requires Oracle Java 17 |
See also
[edit ]References
[edit ]- ^ a b Smith, Jeff (24 October 2022). "What's Next for Oracle SQL Developer? A quick, sneek-peek". That Jeff Smith. Archived from the original on 8 February 2023. Retrieved 1 May 2023.
- ^ "Oracle SQL Developer Downloads" . Retrieved November 19, 2024.
- ^ OTN SQL Developer License
- ^ "Oracle SQL Developer certifications". Oracle Corporation. Retrieved 22 October 2010.
- ^ Murray, Chuck (September 2007). "1 SQL Developer Concepts and Usage: OWA Output Pane". Oracle Database SQL Developer User's Guide Release 1.1. Oracle Corporation. Retrieved 2009年02月04日.
OWA (Oracle Web Agent) or MOD_PLSQL is an Apache (Web Server) extension module.
- ^ "Oracle SQL Developer - Extensions Exchange". oracle.com. July 2013. Retrieved 2018年05月22日.
- ^
Chuck, Murray (June 2009). "Data Modeler Concepts and Usage" (PDF). Oracle SQL Developer Data Modeler User’s Guide Release 2.0. Oracle Corporation. p. 1-1. Retrieved 2010年03月12日.
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 [...]
- ^
"Oracle SQL Developer Data Modeler: Pricing FAQ". Oracle Corpopration. September 2010. Retrieved 2010年10月10日.
Is Oracle SQL Developer Data Modeler free? - Yes.
- ^
Murray, Chuck (February 2011). "SQL Developer Data Modeler User's Guide". docs.oracle.com. Oracle. Retrieved 2014年12月11日.
When you save a database design, the structural information is stored in an XML file (with the extension .dmd)
- ^ "Oracle Data Miner".
- ^ "Oracle SQL Developer". Oracle Corporation. 2008年07月18日. Retrieved 2009年02月04日.
- ^ "SQL Developer 3.2 New Features". Oracle Technology Network. Retrieved 2013年05月01日.
- ^ "SQL Developer Release Notes 4.1.5". www.oracle.com. Retrieved 2018年03月20日.
- ^ "SQL Developer Release Notes 4.2". www.oracle.com. Retrieved 2018年03月20日.
- ^ a b [1] Oracle SQL Developer 17.2 Release Notes
- ^ "SQL Developer Release Notes 17.4". www.oracle.com. Retrieved 2018年01月02日.
- ^ "SQL Developer Release Notes 18.1". www.oracle.com. Retrieved 2018年04月12日.
- ^ "SQL Developer Release Notes 18.2". www.oracle.com. Retrieved 2018年07月12日.
- ^ "SQL Developer Release Notes 18.3". www.oracle.com. Retrieved 2019年01月17日.
- ^ "SQL Developer Release Notes 18.4". www.oracle.com. Retrieved 2019年01月17日.
- ^ "SQL Developer Release Notes 19.1". www.oracle.com. Retrieved 2019年04月10日.
- ^ "SQL Developer Release Notes 19.2". www.oracle.com. Retrieved 2019年08月14日.
- ^ "SQL Developer Release Notes 19.4". www.oracle.com. Retrieved 2019年08月14日.
- ^ "SQL Developer 20.2 Release Notes". www.oracle.com. Retrieved 2020年07月15日.
- ^ "SQL Developer 20.4 Release Notes". www.oracle.com. Retrieved 2021年02月18日.
- ^ "SQL Developer 20.4.1 Release Notes". www.oracle.com. Retrieved 2021年02月24日.
- ^ "SQL Developer 21.2 Release Notes". www.oracle.com. Retrieved 2021年08月23日.
- ^ "SQL Developer 21.4 Release Notes". www.oracle.com. Retrieved 2021年12月25日.
- ^ "SQL Developer 21.4.2 Release Notes". www.oracle.com. Retrieved 2021年12月25日.
- ^ "SQL Developer 22.2 Release Notes". www.oracle.com. Retrieved 2022年09月13日.
- ^ "SQL Developer 22.2.1 Release Notes". www.oracle.com. Retrieved 2022年09月13日.
- ^ "SQL Developer 23.1 Release Notes". www.oracle.com. Retrieved 2023年05月11日.
- ^ "SQL Developer 24.3 Release Notes". www.oracle.com. Retrieved 2024年11月19日.
Bibliography
[edit ]- Harper, Sue (October 20, 2009), Oracle SQL Developer 2.1 (1st ed.), Packt Publishing, p. 496, ISBN 978-1-84719-626-2 , retrieved 2010年01月13日
- Hotka, Dan (October 10, 2006), Oracle SQL Developer Handbook (1st ed.), McGraw-Hill, p. 230, ISBN 0-07-148474-4 , retrieved 2010年01月13日