Jump to content

Oracle SQL Developer

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Tom.c.harris (talk | contribs) at 22:55, 19 August 2010 (→‎Extensions). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Oracle SQL Developer
Developer(s)Oracle Corporation
Stable release
2.1.1.64 / March 1, 2010 (2010-03-01)
Written inJava
Operating systemCross-platform
TypeSQL Integrated development environment
LicenseProprietary OTN SQL Developer License
WebsiteOracle SQL Developer

Oracle SQL Developer is an IDE for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.

Features

In addition to working with Oracle products, Oracle SQL Developer previously supported connections to Microsoft Access, Sybase, and MySQL databases. As of the 1.5 release, though, the product only supports Oracle databases and a variety of third-party plugins. These plugins may be used to connect to a non-Oracle database.

A re-written SQL worksheet (the code-editing element in SQL Developer) will debut with the 2.1 release. Also, as of the 1.5 release, Oracle SQL Developer employs the commercial SQL formatting API by Guido Thelen. Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for PL/SQL.

1.5.4, released in March 2009, is a translation release. Languages include Japanese, Spanish, Italian, German, French, Brazilian Portuguese, Simplified Chinese and Korean.

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.[1]

Extensions

In addition to the extensions provided by Oracle, third-parties have written extensions to add new features and integrate with other products:[2]

New features
Integration with other commercial products

History

Oracle SQL Developer versions[4]
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
1.2.1
1.5
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

See also

References

  1. ^ Murray, Chuck (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 that enables you to create dynamic Web pages from PL/SQL packages and stored procedures. The OWA Output pane enables you to see the HTML output of MOD_PLSQL actions that have been executed in the SQL Worksheet. {{cite web}}: Cite has empty unknown parameters: |dateformat= and |coauthors= (help); Unknown parameter |month= ignored (help)
  2. ^ Extensions, Oracle
  3. ^ Chuck, Murray (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 [...] {{cite web}}: More than one of |pages= and |page= specified (help); Unknown parameter |month= ignored (help)
  4. ^ "Oracle SQL Developer". Oracle Corporation. 2008-07-18. Retrieved 2009-02-04. {{cite web}}: Cite has empty unknown parameters: |month=, |dateformat=, and |coauthors= (help)

Bibliography

Retrieved from "https://en.wikipedia.org/w/index.php?title=Oracle_SQL_Developer&oldid=379863860"