Oracle SQL Developer
| Developer(s) | Oracle Corporation |
|---|---|
| Stable release | 4.0.2.15.21
/ May 5, 2014 |
| 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.
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
- GeoRaptor, Geospatial data viewer
- Insider, Collect statistics for a single Oracle instance and display in real time
- Schema Visualizer allows you to create fully featured Entity Relationship Diagrams (ERD)
- 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.
- Integration with other commercial products
- Red Gate - Deployment Suite for Oracle (Compare schemas and data, deploy all changes.)
- JDBCWizard (produces Java Web Service code to run your existing PL/SQL and SQL statements)
- Hotsos Profiler
- Digger (trace analyzer)
- SVCO Extension (integrated version control solution for Oracle database server schema objects)
History
![[icon]](/wiki/File:Wiki_letter_w_cropped.svg){kind=small} | This section needs expansion. You can help by adding to it. (August 2009) |
| 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[7] |
| 4.0 | December 2013 | |
| 4.0.1 | February 2014 | |
| 4.0.2 | May 2014 |
See also
References
- ^ "Oracle SQL Developer certifications". Oracle Corporation. Retrieved 22 October 2010.
- ^ 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.
{{cite web}}: Cite has empty unknown parameters:|dateformat=and|coauthors=(help) - ^ Extensions, Oracle
- ^
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 [...]
- ^
"Oracle SQL Developer Data Modeler: Pricing FAQ". Oracle Corpopration. September 2010. Retrieved 2010-10-10.
Is Oracle SQL Developer Data Modeler free? Yes.
{{cite web}}: line feed character in|quote=at position 44 (help) - ^ "Oracle SQL Developer". Oracle Corporation. 2008-07-18. Retrieved 2009-02-04.
{{cite web}}: Cite has empty unknown parameters:|month=,|dateformat=, and|coauthors=(help) - ^ "SQL Developer 3.2 New Features". Oracle Technology Network. Oracle Technology Network. Retrieved 2013-05-01.
Bibliography
- Harper, Sue (October 20, 2009), Oracle SQL Developer 2.1 (1st ed.), Packt Publishing, p. 496, ISBN 1-84719-626-8, retrieved 2010-01-13
- Hotka, Dan (October 10, 2006), Oracle SQL Developer Handbook (1st ed.), McGraw-Hill, p. 230, ISBN 0-07-148474-4, retrieved 2010-01-13