Oracle SQL Developer explained
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.[2]
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.[3]
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.[4]
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:[5]
- Integration with other Oracle products:
- SQL Developer Data Modeler operates with and models metadata.[6] Prior to SQL Developer version 3, it constituted a separate (but integrated) free[7] 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.[8]
History
Oracle SQL Developer versions[9] 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. |
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] | | |
See also
Notes and References
- http://www.oracle.com/technetwork/licenses/sqldev-license-152021.html OTN SQL Developer License
- Web site: Oracle SQL Developer certifications. Oracle Corporation. 22 October 2010.
- Web site: Smith . Jeff . What's Next for Oracle SQL Developer? A quick, sneek-peek . That Jeff Smith . 24 October 2022 . 1 May 2023 . https://web.archive.org/web/20230208172815/https://www.thatjeffsmith.com/archive/2022/10/whats-next-for-oracle-sql-developer-a-quick-sneek-peek/ . 8 February 2023.
- Web site: 1 SQL Developer Concepts and Usage: OWA Output Pane. 2009-02-04. Murray. Chuck. September 2007. Oracle Database SQL Developer User's Guide Release 1.1. Oracle Corporation. OWA (Oracle Web Agent) or MOD_PLSQL is an Apache (Web Server) extension module..
- Web site: Oracle SQL Developer - Extensions Exchange . July 2013 . oracle.com . 2018-05-22.
- Web site: Data Modeler Concepts and Usage. Murray. Chuck. June 2009. Oracle SQL Developer Data Modeler User’s Guide Release 2.0. Oracle Corporation. 1-1. 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 [...].
- Web site: Oracle SQL Developer Data Modeler: Pricing FAQ. September 2010. Oracle Corpopration. 2010-10-10. Is Oracle SQL Developer Data Modeler free? - Yes..
- Web site: SQL Developer Data Modeler User's Guide. Murray. Chuck. February 2011. docs.oracle.com. Oracle. 2014-12-11. When you save a database design, the structural information is stored in an XML file (with the extension .dmd).
- Web site: Oracle SQL Developer. 2009-02-04. 2008-07-18. Oracle Corporation.
- Web site: SQL Developer 3.2 New Features . Oracle Technology Network . 2013-05-01.
- Web site: SQL Developer Release Notes 4.1.5. www.oracle.com. 2018-03-20.
- Web site: SQL Developer Release Notes 4.2. www.oracle.com. 2018-03-20.
- http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-172-3802320.html
- Web site: SQL Developer Release Notes 17.4. www.oracle.com. 2018-01-02.
- Web site: SQL Developer Release Notes 18.1. www.oracle.com. 2018-04-12.
- Web site: SQL Developer Release Notes 18.2. www.oracle.com. 2018-07-12.
- Web site: SQL Developer Release Notes 18.3. www.oracle.com. 2019-01-17.
- Web site: SQL Developer Release Notes 18.4. www.oracle.com. 2019-01-17.
- Web site: SQL Developer Release Notes 19.1. www.oracle.com. 2019-04-10.
- Web site: SQL Developer Release Notes 19.2. www.oracle.com. 2019-08-14.
- Web site: SQL Developer Release Notes 19.4. www.oracle.com. 2019-08-14.
- Web site: SQL Developer 20.2 Release Notes. www.oracle.com. 2020-07-15.
- Web site: SQL Developer 20.4 Release Notes. www.oracle.com. 2021-02-18.
- Web site: SQL Developer 20.4.1 Release Notes. www.oracle.com. 2021-02-24.
- Web site: SQL Developer 21.2 Release Notes. www.oracle.com. 2021-08-23.
- Web site: SQL Developer 21.4 Release Notes. www.oracle.com. 2021-12-25.
- Web site: SQL Developer 21.4.2 Release Notes. www.oracle.com. 2021-12-25.
- Web site: SQL Developer 22.2 Release Notes. www.oracle.com. 2022-09-13.
- Web site: SQL Developer 22.2.1 Release Notes. www.oracle.com. 2022-09-13.
- Web site: SQL Developer 23.1 Release Notes. www.oracle.com. 2023-05-11.