Oracle SQL Developer

From Infogalactic: the planetary knowledge core
Jump to: navigation, search
Oracle SQL Developer
Developer(s) Oracle Corporation
Stable release 4.1.3 / December 22, 2015 (2015-12-22)
Written in Java
Operating system Cross-platform
Type SQL Integrated development environment
License Proprietary OTN SQL Developer License
Website Oracle SQL Developer

Oracle SQL Developer (internally often: "sqldeveloper") 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 and a variety of third-party plugins which users may deploy to connect to non-Oracle databases. Oracle SQL Developer works with IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Sybase Adaptive Server, and Teradata databases.[1]

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

Components

Oracle SQL Developer product components include:

  • OWA (Oracle Web Agent or MOD_PLSQL), is an extension module for the Apache web server, and helps in setting up dynamic web-pages from PL/SQL within Oracle SQL Developer.[2]

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:[3]

New features
Integration with other Oracle products
  • SQL Developer Data Modeler operates with and models metadata.[4] Prior to SQL Developer version 3, it constituted a separate (but integrated) free[5] 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.[6]
Integration with other commercial products

History

Oracle SQL Developer versions[7]
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[8]
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

See also

References

<templatestyles src="Reflist/styles.css" />

Cite error: Invalid <references> tag; parameter "group" is allowed only.

Use <references />, or <references group="..." />

Bibliography

  • Lua error in package.lua at line 80: module 'strict' not found.
  • Lua error in package.lua at line 80: module 'strict' not found.

External links

  1. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  2. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  3. ↑ Extensions, Oracle
  4. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  5. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  6. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  7. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  8. ↑ Lua error in package.lua at line 80: module 'strict' not found.
Retrieved from "https://infogalactic.com/w/index.php?title=Oracle_SQL_Developer&oldid=4402063"