imported>Managarmr719: /* History */

2025-04-14T09:29:27Z

History

New page

{{Short description|Free SQL IDE from Oracle Corporation}}
{{Infobox software
| name = Oracle SQL Developer
| logo = Oracle SQL Developer logo.svg
| screenshot = Sql developer main window.png
| developer = [[Oracle Corporation]]
| released = {{Start date and age|2005}}<ref name="next"/>
| discontinued =
| programming language = [[Java (programming language)|Java]]
| platform = [[Java SE]]
| size =
| language =
| language count = 
| language footnote =
| genre = [[SQL]] [[Integrated development environment]]
| license = [[Proprietary software|Proprietary]]<ref>[http://www.oracle.com/technetwork/licenses/sqldev-license-152021.html OTN SQL Developer License]</ref>
| alexa =
| website = {{url|www.oracle.com/technetwork/developer-tools/sql-developer/}}
| standard =
| AsOf =
}}
'''Oracle SQL Developer''' is an [[Integrated development environment]] (IDE) for working with [[SQL]] in [[Oracle database]]s. [[Oracle Corporation]] provides this product [[Freeware|free]]; it uses the [[Java Development Kit]].

== Features ==
Oracle SQL Developer supports [[Oracle database|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.<ref name="OraSQLDevCert">{{cite web|title=Oracle SQL Developer certifications|url=http://www.oracle.com/technetwork/developer-tools/sql-developer/certification-096745.html|publisher=Oracle Corporation|access-date=22 October 2010}}</ref>

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]].<ref name="next">{{cite web |last1=Smith |first1=Jeff |title=What's Next for Oracle SQL Developer? A quick, sneek-peek |url=https://www.thatjeffsmith.com/archive/2022/10/whats-next-for-oracle-sql-developer-a-quick-sneek-peek/ |website=That Jeff Smith |date=24 October 2022 |access-date=1 May 2023 |archive-url=https://web.archive.org/web/20230208172815/https://www.thatjeffsmith.com/archive/2022/10/whats-next-for-oracle-sql-developer-a-quick-sneek-peek/ |archive-date=8 February 2023}}</ref>

== Components ==

Oracle SQL Developer product components include the OWA (Oracle Web Agent or MOD_PLSQL), an extension module for the [[Apache HTTP Server|Apache web server]], and helps in setting up dynamic web-pages from [[PL/SQL]] within Oracle SQL Developer.<ref>{{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.
}}</ref>

== 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:<ref>{{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
}}</ref>

; Integration with other Oracle products:
* SQL Developer Data Modeler operates with and models metadata.<ref>
{{cite web
| 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 [...]
}}
</ref> Prior to SQL Developer version 3, it constituted a separate (but integrated) free<ref>
{{cite web
| 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.
}}
</ref> 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) {{mono|.dmd}} files.<ref>
{{cite web
| 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)
}}
</ref>
* Data Miner<ref>{{cite web|url=https://www.oracle.com/big-data/technologies/dataminer/|title=Oracle Data Miner}}</ref>

== History ==
{| class=wikitable
|+ Oracle SQL Developer versions<ref>{{cite web
| url = http://www.oracle.com/technology/products/database/sql_developer/files/extensions.htm
| title = Oracle SQL Developer
| access-date = 2009-02-04
| date = 2008-07-18
| publisher = Oracle Corporation
}}</ref>
|-
! 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
| [[Oracle APEX|APEX]] listener administration; [[User interface|UI]] enhancements; [[Oracle Database|12c database]] support; bug fixes<ref>
{{cite web
|url = http://www.oracle.com/technetwork/developer-tools/sql-developer/sqldev-newfeatures32-1731840.html
|title = SQL Developer 3.2 New Features
|website = Oracle Technology Network
|access-date = 2013-05-01
}}
</ref>
|-
|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<ref>{{Cite web|url=http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-415-3215755.html|title=SQL Developer Release Notes 4.1.5|website=www.oracle.com|access-date=2018-03-20}}</ref>
|
|-
|4.2.0
|April 2017<ref>{{Cite web|url=http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-42-3215764.html|title=SQL Developer Release Notes 4.2|website=www.oracle.com|access-date=2018-03-20}}</ref>
|
|-
|17.2
|July 2017<ref name="relnotes172">[http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-172-3802320.html] Oracle SQL Developer 17.2 Release Notes</ref>
|New version numbering system with year.quarter used.<ref name="relnotes172" />
|-
|17.4
|Dec 2017<ref>{{Cite web|url=http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-174-4125480.html|title=SQL Developer Release Notes 17.4|website=www.oracle.com|access-date=2018-01-02}}</ref>
|
|-
|18.1
|April 2018<ref>{{Cite web|url=http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-181-4423629.html|title=SQL Developer Release Notes 18.1|website=www.oracle.com|access-date=2018-04-12}}</ref>
|-
|18.2
|July 2018<ref>{{Cite web|url=https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes182-4958969.html|title=SQL Developer Release Notes 18.2|website=www.oracle.com|access-date=2018-07-12}}</ref>
|
|-
|18.3
|October 2018<ref>{{Cite web|url=https://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/dm-relnotes-183-5108835.html|title=SQL Developer Release Notes 18.3|website=www.oracle.com|access-date=2019-01-17}}</ref>
|
|-
|18.4
|January 2019<ref>{{Cite web|url=https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-v184-5231669.html|title=SQL Developer Release Notes 18.4|website=www.oracle.com|access-date=2019-01-17}}</ref>
|
|-
|19.1
|April 2019<ref>{{Cite web|url=https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-191-5458711.html|title=SQL Developer Release Notes 19.1|website=www.oracle.com|access-date=2019-04-10}}</ref>
|
|-
|19.2
|August 2019<ref>{{Cite web|url=https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-192-5592849.html|title=SQL Developer Release Notes 19.2|website=www.oracle.com|access-date=2019-08-14}}</ref>
|
|-
|19.4
|December 2019<ref>{{Cite web|url=https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-194-5908846.html|title=SQL Developer Release Notes 19.4|website=www.oracle.com|access-date=2019-08-14}}</ref>
|
|-
|20.2
|June 2020<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-202.html|title=SQL Developer 20.2 Release Notes|website=www.oracle.com|access-date=2020-07-15}}</ref>
|
|-
|20.4
|January 2021<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-204.html|title=SQL Developer 20.4 Release Notes|website=www.oracle.com|access-date=2021-02-18}}</ref>
|
|-
|20.4.1
|February 2021<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-2041.html|title=SQL Developer 20.4.1 Release Notes|website=www.oracle.com|access-date=2021-02-24}}</ref>
|
|-
|21.2
|August 2021<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.2.html|title=SQL Developer 21.2 Release Notes|website=www.oracle.com|access-date=2021-08-23}}</ref>
|
|-
|21.4
|December 2021<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.4.html|title=SQL Developer 21.4 Release Notes|website=www.oracle.com|access-date=2021-12-25}}</ref>
|
|-
|21.4.2
|January 2022<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.4.2.html|title=SQL Developer 21.4.2 Release Notes|website=www.oracle.com|access-date=2021-12-25}}</ref>
|
|-
|22.2
|June 2022<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-22.2.html|title=SQL Developer 22.2 Release Notes|website=www.oracle.com|access-date=2022-09-13}}</ref>
|Requires Oracle Java 11
|-
|22.2.1
|September 2022<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-22.2.1.html|title=SQL Developer 22.2.1 Release Notes|website=www.oracle.com|access-date=2022-09-13}}</ref>
|
|-
|23.1
|April 2023<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-23.1.0.html|title=SQL Developer 23.1 Release Notes|website=www.oracle.com|access-date=2023-05-11}}</ref>
|
|-
|24.3
|October 2024<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-24.3.html|title=SQL Developer 24.3 Release Notes|website=www.oracle.com|access-date=2024-11-19}}</ref>
|Requires Oracle Java 17
|-
|24.3.1
|December 2024<ref>{{Cite web|url=https://www.oracle.com/tools/sqldev/sqldev-relnotes-24.3.1.html|title=SQL Developer 24.3.1 Release Notes|website=www.oracle.com|access-date=2025-04-14}}</ref>
|
|}

== See also ==
* [[JDeveloper]]
* [[Oracle Developer Suite]]

== References ==
{{reflist}}

==Bibliography==
{{refbegin}}
*{{citation
| first = Sue
| last = Harper
| date = October 20, 2009
| title = Oracle SQL Developer 2.1
| edition = 1st
| publisher = [[Packt|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
}}
{{refend}}

== External links ==
* {{official website|http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html|Oracle SQL Developer Homepage}}
{{Oracle}}

{{DEFAULTSORT:Oracle Sql Developer}}
[[Category:Database administration tools]]
[[Category:SQL clients]]
[[Category:PL/SQL editors]]
[[Category:Oracle software]]
[[Category:Oracle database tools]]
[[Category:Microsoft database software]]
[[Category:Sybase]]
[[Category:2006 software]]

Oracle SQL Developer - Revision history

imported>Managarmr719: /* History */