Oracle SQL Developer
{{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}}
| discontinued =
| programming language = Java
| platform = Java SE
| size =
| language =
| language count =
| language footnote =
| genre = SQL Integrated development environment
| license = Proprietary[http://www.oracle.com/technetwork/licenses/sqldev-license-152021.html OTN SQL Developer License]
| 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 databases. Oracle Corporation provides this product free; it uses the Java Development Kit.
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.{{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}}
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.{{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}}
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:
{{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 [...]
}}
Prior to SQL Developer version 3, it constituted a separate (but integrated) free
{{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.
}}
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.
{{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)
}}
History
| class=wikitable
|+ Oracle SQL Developer versions{{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 }} |
| 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 {{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 }} |
| 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
| |
| 4.2.0
| |
| 17.2 |
| 17.4
| |
| 18.1 |
| 18.2
| |
| 18.3
| |
| 18.4
| |
| 19.1
| |
| 19.2
| |
| 19.4
| |
| 20.2
| |
| 20.4
| |
| 20.4.1
| |
| 21.2
| |
| 21.4
| |
| 21.4.2
| |
| 22.2
|Requires Oracle Java 11 |
| 22.2.1
| |
| 23.1
| |
| 24.3
|Requires Oracle Java 17 |
| 24.3.1
| |
See also
References
{{reflist}}
Bibliography
{{refbegin}}
- {{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
}}
{{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:Oracle database tools