Oracle SQL Developer
| Oracle SQL Developer | |
 | |
| Fejlesztő | Oracle Corporation |
| Legfrissebb fejlesztői kiadás | 4.0 (4.0.0.12.27) (2013. július 11.) +/- |
| Programozási nyelv | Java |
| Operációs rendszer | multi-platform |
| Kategória | SQL IDE |
| Licenc | Kereskedelmi OTN SQL Developer License |
| [Oracle SQL Developer Az Oracle SQL Developer weboldala] | |
 |
Ez a szócikk/szakasz most épül, még dolgoznak az első verzión! |
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.
Főbb funkciók
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.
Komponensek
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]
Kiterjesztések
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
- 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 has become 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.)
- OrindaBuild (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)
Történet
| Verzió | Kiadás dátuma | Leírás |
|---|---|---|
| Az 1.0-ás verzió előtt | Az 1.0-ás verzió előtt, az Oracle Corporation a terméket Raptor néven jelölte. | |
| 1.0 | 2006. március | Első kiadás |
| 1.1 | ||
| 1.2.1 | ||
| 1.5 | ||
| 1.5.1 | 2008. június | |
| 1.5.3 | 2008. december | |
| 1.5.4 | 2009. március | |
| 1.5.5 | 2009. július | |
| 2.1 RC1 | 2009. december | |
| 2.1 Patch 1 | 2010. március | |
| 3.0 | 2011. március |
Lásd még
Referencia
- ↑ Oracle SQL Developer certifications. Oracle Corporation. (Hozzáférés: 2010. október 22.)
- ↑ Murray, Chuck: 1 SQL Developer Concepts and Usage: OWA Output Pane. Oracle Database SQL Developer User's Guide Release 1.1. Oracle Corporation, 2007. September. (Hozzáférés: 2009. február 4.) „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.”
- ↑ Extensions, Oracle
- ↑ Chuck, Murray: Data Modeler Concepts and Usage (PDF). Oracle SQL Developer Data Modeler User’s Guide Release 2.0 pp. 120. Oracle Corporation, 2009. June. (Hozzáférés: 2010. március 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, 2010. September. (Hozzáférés: 2010. október 10.) „Is Oracle SQL Developer Data Modeler free? Yes.”
- ↑ Oracle SQL Developer. Oracle Corporation, 2008. július 18. (Hozzáférés: 2009. február 4.)
Bibliography
- Harper, Sue (October 20, 2009), Oracle SQL Developer 2.1 (1st ed.), Packt Publishing, p. 496, ISBN 1847196268, <http://www.packtpub.com/oracle-sql-developer-2-1/book>. Hozzáférés ideje: 2010-01-13
- Hotka, Dan (October 10, 2006), Oracle SQL Developer Handbook (1st ed.), McGraw-Hill, p. 230, ISBN 0071484744, <http://www.mhprofessional.com/product.php?cat=7&isbn=0071484744>. Hozzáférés ideje: 2010-01-13