Oracle SQL Developer
Encyclopedia
In computing
Computing
Computing is usually defined as the activity of using and improving computer hardware and software. It is the computer-specific part of information technology...

, Oracle SQL Developer is an Integrated development environment
Integrated development environment
An integrated development environment is a software application that provides comprehensive facilities to computer programmers for software development...

 (IDE) for working with SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....

 in Oracle database
Oracle database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....

s. Oracle Corporation
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing hardware systems and enterprise software products – particularly database management systems...

  provides this product free
Freeware
Freeware is computer software that is available for use at no cost or for an optional fee, but usually with one or more restricted usage rights. Freeware is in contrast to commercial software, which is typically sold for profit, but might be distributed for a business or commercial purpose in the...

; it uses the Java Development Kit
Java Development Kit
The Java Development Kit is an Oracle Corporation product aimed at Java developers. Since the introduction of Java, it has been by far the most widely used Java SDK. On 17 November 2006, Sun announced that it would be released under the GNU General Public License , thus making it free software...

.

Features

Oracle SQL Developer supports Oracle products
Oracle database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....

 and a variety of third-party plugins which users may deploy to connect to non-Oracle databases. Oracle SQL Developer works with IBM DB2
IBM DB2
The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions...

, Microsoft Access
Microsoft Access
Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of...

, Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...

, MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...

, Sybase
Sybase
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....

 Adaptive Server, and Teradata
Teradata
Teradata Corporation is a vendor specializing in data warehousing and analytic applications. Its products are commonly used by companies to manage data warehouses for analytics and business intelligence purposes. Teradata was formerly a division of NCR Corporation, with the spinoff from NCR on...

 databases.

Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for PL/SQL
PL/SQL
PL/SQL is Oracle Corporation's procedural extension language for SQL and the Oracle relational database...

.

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=" (without quotes) to \bin\sqldeveloper.conf.

Components

Oracle SQL Developer product components include:
  • OWA (Oracle Web Agent or MOD_PLSQL), is an extension module for the Apache web server
    Apache HTTP Server
    The Apache HTTP Server, commonly referred to as Apache , is web server software notable for playing a key role in the initial growth of the World Wide Web. In 2009 it became the first web server software to surpass the 100 million website milestone...

    , and helps in setting up dynamic web-pages from PL/SQL
    PL/SQL
    PL/SQL is Oracle Corporation's procedural extension language for SQL and the Oracle relational database...

     within Oracle SQL Developer.

Extensions

In addition to the extensions provided by Oracle, third-parties have written extensions to add new features and integrate with other products:

New features:
  • GeoRaptor, Geospatial
    Geospatial
    Geospatial analysis is an approach to applying statistical analysis and other informational techniques to geographically based data. Such analysis employs spatial software and analytical methods with terrestrial or geographic datasets, including geographic information systems and...

    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. Prior to SQL Developer version 3, it constituted a separate (but integrated) free 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:

History

Oracle SQL Developer versions
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
1.2.1
1.5
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

External links

The source of this article is wikipedia, the free encyclopedia.  The text of this article is licensed under the GFDL.
 
x
OK