Menu
Home Explore People Places Arts History Plants & Animals Science Life & Culture Technology
On this page
Oracle SQL Developer
Free SQL IDE from Oracle Corporation

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.

Related Image Collections Add Image
Profiles
1 Image
We don't have any YouTube videos related to Oracle SQL Developer yet.
We don't have any PDF documents related to Oracle SQL Developer yet.
We don't have any Books related to Oracle SQL Developer yet.
We don't have any archived web articles related to Oracle SQL Developer yet.

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) free6 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.7
  • Data Miner8

History

Oracle SQL Developer versions9
VersionRelease DateDescription
Releases prior to 1.0Prior to version 1.0, Oracle Corporation labeled the product "Raptor"
1.0March 2006The first release
1.1December 2006
1.2.1August 2007
1.5April 2008
1.5.1June 2008
1.5.3December 2008
1.5.4March 2009
1.5.5July 2009
2.1 RC1December 2009
2.1 Patch 1March 2010
3.0March 2011
3.1February 2012
3.2August 2012APEX listener administration; UI enhancements; 12c database support; bug fixes10
4.0December 2013
4.0.1February 2014
4.0.2May 2014
4.0.3September 2014
4.1.1June 2015
4.1.2October 2015Requires Java 8
4.1.3December 2015
4.1.5September 201611
4.2.0April 201712
17.2July 201713New version numbering system with year.quarter used.14
17.4Dec 201715
18.1April 201816
18.2July 201817
18.3October 201818
18.4January 201919
19.1April 201920
19.2August 201921
19.4December 201922
20.2June 202023
20.4January 202124
20.4.1February 202125
21.2August 202126
21.4December 202127
21.4.2January 202228
22.2June 202229Requires Oracle Java 11
22.2.1September 202230
23.1April 202331
24.3October 202432Requires Oracle Java 17

See also

Bibliography

References

  1. "Oracle SQL Developer certifications". Oracle Corporation. Retrieved 22 October 2010. http://www.oracle.com/technetwork/developer-tools/sql-developer/certification-096745.html ↩

  2. 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. https://web.archive.org/web/20230208172815/https://www.thatjeffsmith.com/archive/2022/10/whats-next-for-oracle-sql-developer-a-quick-sneek-peek/ ↩

  3. 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. http://download.oracle.com/docs/cd/B28359_01/appdev.111/b31695/intro.htm ↩

  4. "Oracle SQL Developer - Extensions Exchange". oracle.com. July 2013. Retrieved 2018-05-22. http://www.oracle.com/technetwork/developer-tools/sql-developer/extensions-083825.html ↩

  5. 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 [...] http://download.oracle.com/docs/cd/E15276_01/doc.20/e13677.pdf ↩

  6. "Oracle SQL Developer Data Modeler: Pricing FAQ". Oracle Corpopration. September 2010. Retrieved 2010-10-10. Is Oracle SQL Developer Data Modeler free? - Yes. http://www.oracle.com/technetwork/developer-tools/datamodeler/pricing-faq-101047.html ↩

  7. 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) https://docs.oracle.com/cd/E18464_01/doc.30/e15802/data_modeling.htm#BABCFHIH ↩

  8. "Oracle Data Miner". https://www.oracle.com/big-data/technologies/dataminer/ ↩

  9. "Oracle SQL Developer". Oracle Corporation. 2008-07-18. Retrieved 2009-02-04. http://www.oracle.com/technology/products/database/sql_developer/files/extensions.htm ↩

  10. "SQL Developer 3.2 New Features". Oracle Technology Network. Retrieved 2013-05-01. http://www.oracle.com/technetwork/developer-tools/sql-developer/sqldev-newfeatures32-1731840.html ↩

  11. "SQL Developer Release Notes 4.1.5". www.oracle.com. Retrieved 2018-03-20. http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-415-3215755.html ↩

  12. "SQL Developer Release Notes 4.2". www.oracle.com. Retrieved 2018-03-20. http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-42-3215764.html ↩

  13. [1] Oracle SQL Developer 17.2 Release Notes http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-172-3802320.html ↩

  14. [1] Oracle SQL Developer 17.2 Release Notes http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-172-3802320.html ↩

  15. "SQL Developer Release Notes 17.4". www.oracle.com. Retrieved 2018-01-02. http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-174-4125480.html ↩

  16. "SQL Developer Release Notes 18.1". www.oracle.com. Retrieved 2018-04-12. http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-181-4423629.html ↩

  17. "SQL Developer Release Notes 18.2". www.oracle.com. Retrieved 2018-07-12. https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes182-4958969.html ↩

  18. "SQL Developer Release Notes 18.3". www.oracle.com. Retrieved 2019-01-17. https://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/dm-relnotes-183-5108835.html ↩

  19. "SQL Developer Release Notes 18.4". www.oracle.com. Retrieved 2019-01-17. https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-v184-5231669.html ↩

  20. "SQL Developer Release Notes 19.1". www.oracle.com. Retrieved 2019-04-10. https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-191-5458711.html ↩

  21. "SQL Developer Release Notes 19.2". www.oracle.com. Retrieved 2019-08-14. https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-192-5592849.html ↩

  22. "SQL Developer Release Notes 19.4". www.oracle.com. Retrieved 2019-08-14. https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-194-5908846.html ↩

  23. "SQL Developer 20.2 Release Notes". www.oracle.com. Retrieved 2020-07-15. https://www.oracle.com/tools/sqldev/sqldev-relnotes-202.html ↩

  24. "SQL Developer 20.4 Release Notes". www.oracle.com. Retrieved 2021-02-18. https://www.oracle.com/tools/sqldev/sqldev-relnotes-204.html ↩

  25. "SQL Developer 20.4.1 Release Notes". www.oracle.com. Retrieved 2021-02-24. https://www.oracle.com/tools/sqldev/sqldev-relnotes-2041.html ↩

  26. "SQL Developer 21.2 Release Notes". www.oracle.com. Retrieved 2021-08-23. https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.2.html ↩

  27. "SQL Developer 21.4 Release Notes". www.oracle.com. Retrieved 2021-12-25. https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.4.html ↩

  28. "SQL Developer 21.4.2 Release Notes". www.oracle.com. Retrieved 2021-12-25. https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.4.2.html ↩

  29. "SQL Developer 22.2 Release Notes". www.oracle.com. Retrieved 2022-09-13. https://www.oracle.com/tools/sqldev/sqldev-relnotes-22.2.html ↩

  30. "SQL Developer 22.2.1 Release Notes". www.oracle.com. Retrieved 2022-09-13. https://www.oracle.com/tools/sqldev/sqldev-relnotes-22.2.1.html ↩

  31. "SQL Developer 23.1 Release Notes". www.oracle.com. Retrieved 2023-05-11. https://www.oracle.com/tools/sqldev/sqldev-relnotes-23.1.0.html ↩

  32. "SQL Developer 24.3 Release Notes". www.oracle.com. Retrieved 2024-11-19. https://www.oracle.com/tools/sqldev/sqldev-relnotes-24.3.html ↩