Oracle SQL Developer

Oracle SQL Developer
Developer(s) Oracle Corporation
Stable release 3.0 / March 29, 2011; 7 months ago (2011-03-29)
Written in Java
Operating system Cross-platform
Type SQL Integrated development environment
License Proprietary OTN SQL Developer License
Website Oracle SQL Developer

In computing, 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.



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.

Oracle Corporation planned a re-written SQL worksheet (the code-editing element in SQL Developer) to debut with the 2.1 release.

As of the 1.5 release, Oracle SQL Developer employs the commercial SQL formatting API by Guido Thelen.

1.5.4, released in March 2009, is a translation release. Languages include Japanese, Spanish, Italian, German, French, Brazilian Portuguese, Simplified Chinese and Korean. How the software chooses the wrong language remains a mystery. However, users can set a language manually by adding "AddVMOption -Duser.language=<one_of_the_supported_languages>" (without quotes) to <SQL_Developer_installation_directory>\bin\sqldeveloper.conf.


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]


In addition to the extensions provided by Oracle, third-parties have written extensions to add new features and 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 has become an integrated part of the overall tool.
Integration with other commercial products


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

See also


  1. ^ "Oracle SQL Developer certifications". Oracle Corporation. Retrieved 22 October 2010. 
  2. ^ Murray, Chuck (September 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." 
  3. ^ Extensions, Oracle
  4. ^ Chuck, Murray (June 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 [...]" 
  5. ^ "Oracle SQL Developer Data Modeler: Pricing FAQ". Oracle Corpopration. September 2010. Retrieved 2010-10-10. "Is Oracle SQL Developer Data Modeler free? Yes." 
  6. ^ "Oracle SQL Developer". Oracle Corporation. 2008-07-18. Retrieved 2009-02-04. 


External links

Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Oracle SQL Developer — Demonstration of Oracle SQL Developer GUI Ти …   Википедия

  • Oracle SQL Developer — est un EDI pour faire du SQL sur les bases de données Oracle. Il est fourni gratuitement par Oracle; il utilise le Java Development Kit. Fonctionnalités Oracle SQL Developer supporte les produits Oracle ainsi que des plugins qui permettent de se… …   Wikipédia en Français

  • SQL Developer — Oracle SQL Developer Entwickler Oracle Aktuelle Version 3.0 (29. März 2011) Betriebssystem Windows, Linux, Mac OS Programmier­sprache …   Deutsch Wikipedia

  • SQL Developer — may refer to:* Oracle SQL Developer, a free SQL IDE from Oracle Corporation * PL/SQL Developer, an IDE for PL/SQL development from Allround Automations * SOLYP SQL Developer, a generic proprietary database tool written by Jan Borchers …   Wikipedia

  • Oracle Database — Developer(s) Oracle Corporation Development status Active Written in …   Wikipedia

  • Oracle Application Express — Developer(s) Oracle Corporation Stable release 4.1 / August 24, 2011; 2 months ago ( …   Wikipedia

  • Oracle Corporation — Type Public Traded as NYSE: ORCL NASDAQ:  …   Wikipedia

  • Oracle (DBMS) — Oracle Datenbank Basisdaten Entwickler: Oracle Aktuelle Version: 11g (10. Juli 2007) …   Deutsch Wikipedia

  • Oracle Database — Oracle Datenbank Basisdaten Entwickler: Oracle Aktuelle Version: 11g (10. Juli 2007) …   Deutsch Wikipedia

  • SQL*Plus — Oracle Datenbank Basisdaten Entwickler: Oracle Aktuelle Version: 11g (10. Juli 2007 …   Deutsch Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”

We are using cookies for the best presentation of our site. Continuing to use this site, you agree with this.