Oracle SQL Developer: Difference between revisions

Content deleted Content added

Inline

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

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)

External links

This software article is a stub. You can help Wikipedia by expanding it.

[1] ITworld

[2] 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)

[3] Extensions, Oracle

[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)

[1]

[2]

[3]

[4]

@@ Line 87: / Line 87: @@
 == 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://www.quest.com/toad-for-oracle/ Toad for Oracle (Quest Software)]
 == See also ==