Oracle SQL Developer

---

title: "Oracle SQL Developer" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["database-administration-tools", "sql-clients", "pl/sql-editors", "oracle-software", "oracle-database-tools", "microsoft-database-software", "sybase", "2006-software"] description: "Free SQL IDE from Oracle Corporation" topic_path: "technology/databases" source: "https://en.wikipedia.org/wiki/Oracle_SQL_Developer" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0

::summary Free SQL IDE from Oracle Corporation ::

::data[format=table title="Infobox software"]

Field	Value
name	Oracle SQL Developer
logo	Oracle SQL Developer logo.svg
screenshot	Sql developer main window.png
developer	Oracle Corporation
released
programming language	Java
platform	Java SE
language count
genre	SQL Integrated development environment
license	Proprietary
website
::

| name = Oracle SQL Developer | logo = Oracle SQL Developer logo.svg | screenshot = Sql developer main window.png | developer = Oracle Corporation | released = | discontinued = | programming language = Java | platform = Java SE | size = | language = | language count = | language footnote = | genre = SQL Integrated development environment | license = Proprietary | alexa = | website = | standard = | AsOf = 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.

History

The SQL Developer product was initially created in response to a large invoice sent from Quest Software to Oracle Corporation over the use of Quest's TOAD product within Oracle's consulting group - Quest claimed that Oracle used the tool far more extensively than their license allowed for.

Larry Ellison personally called the lead developer during lunch early in 2006, stating that the payment just made to Quest in response to this (per Oracle's view) unwarranted license charge would be the last time Oracle paid the company for TOAD, and the developer was instructed to build a product that could replace it.

The initial release of SQL Developer was quickly put together, and released to Oracle internally immediately.

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.

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.

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.{{cite web | url = http://download.oracle.com/docs/cd/B28359_01/appdev.111/b31695/intro.htm | title = 1 SQL Developer Concepts and Usage: OWA Output Pane | access-date = 2009-02-04 | last = Murray | first = Chuck |date= September 2007 | work = Oracle Database SQL Developer User's Guide Release 1.1 | publisher = Oracle Corporation | quote = OWA (Oracle Web Agent) or MOD_PLSQL is an Apache (Web Server) extension module.

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:{{cite web |url=http://www.oracle.com/technetwork/developer-tools/sql-developer/extensions-083825.html |title=Oracle SQL Developer - Extensions Exchange |date=July 2013 |website=oracle.com |access-date=2018-05-22

; Integration with other Oracle products:

• SQL Developer Data Modeler operates with and models metadata. | url = http://download.oracle.com/docs/cd/E15276_01/doc.20/e13677.pdf | title = Data Modeler Concepts and Usage | first = Murray | last = Chuck | date = June 2009 | work = Oracle SQL Developer Data Modeler User’s Guide Release 2.0 | publisher = Oracle Corporation | page = 1-1 | access-date = 2010-03-12 | quote = 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 [...] Prior to SQL Developer version 3, it constituted a separate (but integrated) free | url = http://www.oracle.com/technetwork/developer-tools/datamodeler/pricing-faq-101047.html | title = Oracle SQL Developer Data Modeler: Pricing FAQ |date=September 2010 | publisher = Oracle Corpopration | access-date = 2010-10-10 | quote = Is Oracle SQL Developer Data Modeler free? - Yes. 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. | url = https://docs.oracle.com/cd/E18464_01/doc.30/e15802/data_modeling.htm#BABCFHIH | title = SQL Developer Data Modeler User's Guide | last1 = Murray | first1 = Chuck | date = February 2011 | website = docs.oracle.com | publisher = Oracle | access-date = 2014-12-11 | quote = When you save a database design, the structural information is stored in an XML file (with the extension .dmd)
• Data Miner

History

::data[format=table title="Oracle SQL Developer versions{{cite web"]

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
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
4.2.0	April 2017
17.2	July 2017	New version numbering system with year.quarter used.
17.4	Dec 2017
18.1	April 2018
18.2	July 2018
18.3	October 2018
18.4	January 2019
19.1	April 2019
19.2	August 2019
19.4	December 2019
20.2	June 2020
20.4	January 2021
20.4.1	February 2021
21.2	August 2021
21.4	December 2021
21.4.2	January 2022
22.2	June 2022	Requires Oracle Java 11
22.2.1	September 2022
23.1	April 2023
24.3	October 2024	Requires Oracle Java 17
24.3.1	December 2024
::

References

Bibliography

• {{citation |first = Sue |last = Harper |date = October 20, 2009 |title = Oracle SQL Developer 2.1 |edition = 1st |publisher = Packt Publishing |page = 496 |isbn = 978-1-84719-626-2 |url = http://www.packtpub.com/oracle-sql-developer-2-1/book |access-date = 2010-01-13
• {{citation |first1 = Dan |last1 = Hotka |date = October 10, 2006 |title = Oracle SQL Developer Handbook |edition = 1st |publisher = McGraw-Hill |page = 230 |isbn = 0-07-148474-4 |url = http://www.mhprofessional.com/product.php?cat=7&isbn=0071484744 |access-date = 2010-01-13

References

1. [http://www.oracle.com/technetwork/licenses/sqldev-license-152021.html OTN SQL Developer License]
2. This was witnessed personally by the group of Oracle employees that were sitting at the table, including myself.
3. "Oracle SQL Developer certifications". Oracle Corporation.
4. (24 October 2022). "What's Next for Oracle SQL Developer? A quick, sneek-peek".
5. "Oracle Data Miner".
6. "SQL Developer Release Notes 4.1.5".
7. "SQL Developer Release Notes 4.2".
8. [http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-172-3802320.html] Oracle SQL Developer 17.2 Release Notes
9. "SQL Developer Release Notes 17.4".
10. "SQL Developer Release Notes 18.1".
11. "SQL Developer Release Notes 18.2".
12. "SQL Developer Release Notes 18.3".
13. "SQL Developer Release Notes 18.4".
14. "SQL Developer Release Notes 19.1".
15. "SQL Developer Release Notes 19.2".
16. "SQL Developer Release Notes 19.4".
17. "SQL Developer 20.2 Release Notes".
18. "SQL Developer 20.4 Release Notes".
19. "SQL Developer 20.4.1 Release Notes".
20. "SQL Developer 21.2 Release Notes".
21. "SQL Developer 21.4 Release Notes".
22. "SQL Developer 21.4.2 Release Notes".
23. "SQL Developer 22.2 Release Notes".
24. "SQL Developer 22.2.1 Release Notes".
25. "SQL Developer 23.1 Release Notes".
26. "SQL Developer 24.3 Release Notes".
27. "SQL Developer 24.3.1 Release Notes".

::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::