Oracle SQL Developer: Difference between revisions
Gazzathebad (talk | contribs) |
|||
Line 87: | Line 87: | ||
== Competing tools for Oracle development == |
== Competing tools for Oracle development == |
||
* [http://www.sqlgate.com/product/product_detail.html?gubun=oracle_SQLGate for Oracle] |
* [http://www.sqlgate.com/product/product_detail.html?gubun=oracle_SQLGate SQLGate for Oracle] |
||
* [http://oracle.navicat.com Navicat for Oracle] |
* [http://oracle.navicat.com Navicat for Oracle] |
||
* [http://www.quest.com/toad-for-oracle/ Toad for Oracle (Quest Software)] |
|||
== See also == |
== See also == |
Revision as of 21:41, 27 March 2009
Oracle SQL Developer, a free SQL IDE provided by Oracle Corporation, permits users to work with Oracle databases. Prior to version 1.0 Oracle Corporation called the product "Raptor".[1]
It depends on the Java Development Kit.
Features
In addition to working with Oracle products, SQL Developer used to support connections to Microsoft Access, Sybase, and MySQL databases, but as of version 1.5 the product supports only Oracle databases.
It supports Sherlock search plugins, and opens the requested search results in the configured web browser.
Components
SQL Developer product components include:
- OWA (or Oracle Web Agent or MOD_PLSQL) an extension module for the Apache web server, helps in setting up dynamic web-pages from PL/SQL within SQL Developer[2]
Extensions
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
- GeoRaptor, Geospatial data viewer
- Insider, Collect statistics for a single Oracle instance and display in real time
- Error code lookup, Look up oracle error codes
- Integration with other commercial products
- OrindaBuild (produces Java code)
- Hotsos Profiler
- Digger (trace analyzer)
- CWD4ALL (Common Warehouse Design for All: data modeling and design)
Versions
The Oracle website notes the following versions of Oracle SQL Developer:[4]
- 1.0, released in March 2006
- 1.1
- 1.2.1
- 1.5
- 1.5.1, released in June 2008
- 1.5.3, released in December 2008
- 1.5.4, released in March 2009
Competing tools for Oracle development
See also
References
- ^ ITworld
- ^ 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) - ^ Extensions, Oracle
- ^ "Oracle SQL Developer". Oracle Corporation. 2008-07-18. Retrieved 2009-02-04.
{{cite web}}
: Cite has empty unknown parameters:|month=
,|dateformat=
, and|coauthors=
(help)
Further reading
- Murach's Oracle SQL and PL/SQL