Wikipedia

Oracle SQL Developer

Oracle SQL Developeris anIntegrated development environment(IDE) for working withSQLinOracle databases.Oracle Corporationprovides this productfree;it uses theJava Development Kit.

Oracle SQL Developer
Developer(s)Oracle Corporation
Initial release2005;19 years ago(2005)[1]
Stable release24.3.0.284.2209 (October 17, 2024;38 days ago(2024-10-17)[2])[±]
Written inJava
PlatformJava SE
TypeSQLIntegrated development environment
LicenseProprietary[3]
Websitewww.oracle.com/technetwork/developer-tools/sql-developer/

Features

edit

Oracle SQL Developer supportsOracle 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 withIBM Db2,Microsoft Access,Microsoft SQL Server,MySQL,SybaseAdaptive Server,Amazon RedshiftandTeradatadatabases.[4]

Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring forPL/SQL.

Future versions of Oracle SQL Developer will useVisual Studio Code.[1]

Components

edit

Oracle SQL Developer product components include the OWA (Oracle Web Agent or MOD_PLSQL), an extension module for theApache web server,and helps in setting up dynamic web-pages fromPL/SQLwithin 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).dmdfiles.[9]
  • Data Miner[10]

History

edit
Oracle SQL Developer versions[11]
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 APEXlistener administration;UIenhancements;12c databasesupport; 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
  1. ^abSmith, Jeff (24 October 2022)."What's Next for Oracle SQL Developer? A quick, sneek-peek".That Jeff Smith.Archived fromthe originalon 8 February 2023.Retrieved1 May2023.
  2. ^"Oracle SQL Developer Downloads".RetrievedNovember 19,2024.
  3. ^OTN SQL Developer License
  4. ^"Oracle SQL Developer certifications".Oracle Corporation.Retrieved22 October2010.
  5. ^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.Retrieved2009-02-04.OWA (Oracle Web Agent) or MOD_PLSQL is an Apache (Web Server) extension module.
  6. ^"Oracle SQL Developer - Extensions Exchange".oracle.com.July 2013.Retrieved2018-05-22.
  7. ^ 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.Retrieved2010-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 [...]
  8. ^ "Oracle SQL Developer Data Modeler: Pricing FAQ".Oracle Corpopration. September 2010.Retrieved2010-10-10.Is Oracle SQL Developer Data Modeler free? - Yes.
  9. ^ Murray, Chuck (February 2011)."SQL Developer Data Modeler User's Guide".docs.oracle.com.Oracle.Retrieved2014-12-11.When you save a database design, the structural information is stored in an XML file (with the extension.dmd)
  10. ^"Oracle Data Miner".
  11. ^"Oracle SQL Developer".Oracle Corporation. 2008-07-18.Retrieved2009-02-04.
  12. ^ "SQL Developer 3.2 New Features".Oracle Technology Network.Retrieved2013-05-01.
  13. ^"SQL Developer Release Notes 4.1.5".www.oracle.com.Retrieved2018-03-20.
  14. ^"SQL Developer Release Notes 4.2".www.oracle.com.Retrieved2018-03-20.
  15. ^ab[1]Oracle SQL Developer 17.2 Release Notes
  16. ^"SQL Developer Release Notes 17.4".www.oracle.com.Retrieved2018-01-02.
  17. ^"SQL Developer Release Notes 18.1".www.oracle.com.Retrieved2018-04-12.
  18. ^"SQL Developer Release Notes 18.2".www.oracle.com.Retrieved2018-07-12.
  19. ^"SQL Developer Release Notes 18.3".www.oracle.com.Retrieved2019-01-17.
  20. ^"SQL Developer Release Notes 18.4".www.oracle.com.Retrieved2019-01-17.
  21. ^"SQL Developer Release Notes 19.1".www.oracle.com.Retrieved2019-04-10.
  22. ^"SQL Developer Release Notes 19.2".www.oracle.com.Retrieved2019-08-14.
  23. ^"SQL Developer Release Notes 19.4".www.oracle.com.Retrieved2019-08-14.
  24. ^"SQL Developer 20.2 Release Notes".www.oracle.com.Retrieved2020-07-15.
  25. ^"SQL Developer 20.4 Release Notes".www.oracle.com.Retrieved2021-02-18.
  26. ^"SQL Developer 20.4.1 Release Notes".www.oracle.com.Retrieved2021-02-24.
  27. ^"SQL Developer 21.2 Release Notes".www.oracle.com.Retrieved2021-08-23.
  28. ^"SQL Developer 21.4 Release Notes".www.oracle.com.Retrieved2021-12-25.
  29. ^"SQL Developer 21.4.2 Release Notes".www.oracle.com.Retrieved2021-12-25.
  30. ^"SQL Developer 22.2 Release Notes".www.oracle.com.Retrieved2022-09-13.
  31. ^"SQL Developer 22.2.1 Release Notes".www.oracle.com.Retrieved2022-09-13.
  32. ^"SQL Developer 23.1 Release Notes".www.oracle.com.Retrieved2023-05-11.
  33. ^"SQL Developer 24.3 Release Notes".www.oracle.com.Retrieved2024-11-19.

Bibliography

edit
edit
Retrieved from "https://en.wikipedia.org/w/index.php?title=Oracle_SQL_Developer&oldid=1258393804"