Developer(s) | Oracle Corporation |
---|---|
Stable release | 23.1.1.345.2114 (December 15, 2023[1]) [±] |
Written in | Java |
Platform | Java SE |
Type | SQL Integrated development environment |
License | Proprietary [2] |
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.
Oracle SQL Developer supports Oracle products. In the past a variety of third-party plugins was 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. [3]
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. [4]
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]
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]
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 [11] |
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 [12] | |
4.2.0 | April 2017 [13] | |
17.2 | July 2017 [14] | New version numbering system with year.quarter used. [14] |
17.4 | Dec 2017 [15] | |
18.1 | April 2018 [16] | |
18.2 | July 2018 [17] | |
18.3 | October 2018 [18] | |
18.4 | January 2019 [19] | |
19.1 | April 2019 [20] | |
19.2 | August 2019 [21] | |
19.4 | December 2019 [22] | |
20.2 | June 2020 [23] | |
20.4 | January 2021 [24] | |
20.4.1 | February 2021 [25] | |
21.2 | August 2021 [26] | |
21.4 | December 2021 [27] | |
21.4.2 | January 2022 [28] | |
22.2 | June 2022 [29] | Requires Oracle Java 11 |
22.2.1 | September 2022 [30] | |
23.1 | April 2023 [31] |
OWA (Oracle Web Agent) or MOD_PLSQL is an Apache (Web Server) extension module.
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 [...]
Is Oracle SQL Developer Data Modeler free? - Yes.
When you save a database design, the structural information is stored in an XML file (with the extension .dmd)
Developer(s) | Oracle Corporation |
---|---|
Stable release | 23.1.1.345.2114 (December 15, 2023[1]) [±] |
Written in | Java |
Platform | Java SE |
Type | SQL Integrated development environment |
License | Proprietary [2] |
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.
Oracle SQL Developer supports Oracle products. In the past a variety of third-party plugins was 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. [3]
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. [4]
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]
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]
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 [11] |
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 [12] | |
4.2.0 | April 2017 [13] | |
17.2 | July 2017 [14] | New version numbering system with year.quarter used. [14] |
17.4 | Dec 2017 [15] | |
18.1 | April 2018 [16] | |
18.2 | July 2018 [17] | |
18.3 | October 2018 [18] | |
18.4 | January 2019 [19] | |
19.1 | April 2019 [20] | |
19.2 | August 2019 [21] | |
19.4 | December 2019 [22] | |
20.2 | June 2020 [23] | |
20.4 | January 2021 [24] | |
20.4.1 | February 2021 [25] | |
21.2 | August 2021 [26] | |
21.4 | December 2021 [27] | |
21.4.2 | January 2022 [28] | |
22.2 | June 2022 [29] | Requires Oracle Java 11 |
22.2.1 | September 2022 [30] | |
23.1 | April 2023 [31] |
OWA (Oracle Web Agent) or MOD_PLSQL is an Apache (Web Server) extension module.
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 [...]
Is Oracle SQL Developer Data Modeler free? - Yes.
When you save a database design, the structural information is stored in an XML file (with the extension .dmd)