Oracle SQL Developer

The SQL Developer is a development environment (IDE ) from Oracle SQL, PL / SQL, as well as a management tool for databases. The SQL Developer is based on Java and therefore requires a Java runtime environment, but that also runs on multiple platforms. Originally called the SQL Developer " Project Raptor".

The official support extends though only on Oracle databases (version 10g ) and Microsoft Access, through the Java-based architecture, but can also be incorporated JDBC driver other databases such as MySQL, but are not there several Oracle - specific functions available.

Functions

SQL

With SQL Developer, as with any SQL client, SQL queries are sent to a database.

Viewing, creating and editing database objects

For many types of database objects are available in the Graphical Interface Forms for easier viewing and changing. So can be created without any knowledge of SQL, modified or deleted, for example, sequences or table definitions. Data in tables can be changed directly in the surface, deleted or added. If a table is called loads of SQL Developer in its default settings, only a portion (eg 50 lines ) to avoid even with large tables to long waiting times. The data displayed in a table can be sorted and filtered.

Performance

With the performance features of Oracle databases can be created in the surface of a SQL statement both a trace and an execution plan. With this information it is possible professionals to optimize and to identify problem areas, the SQL statements.

IMPORT / EXPORT

The software also includes many opportunities for export and import of data. The structure of database objects can be exported in DDL statements. The content of the tables, for example, in HTML pages, CSV or Excel files are stored or it can even SQL (insert statements ) are generated. A data import is possible from CSV and Microsoft Excel files.

PL / SQL

Furthermore, the SQL Developer provides the ability functions and procedures in the executable directly to an Oracle database programming language PL / SQL to develop. But besides an editor with syntax highlighting is also a debugger. This accesses the debugging options of the Oracle database. Since version 2.1 also unit tests for PL / SQL programs can be created.

Compounds

In a window to allow access to different databases manage. It can be used simultaneously connect to different databases. Connections are created and stored with the usual information ( user, password, etc.). They are from then on, even after a restart. If a connection is set up the database objects that database are listed in a tree structure, sorted by type.

Migration

For the migration from other DBMS (Sybase, Microsoft SQL Server and Access ) to Oracle functions are available.

Availability

The SQL Developer is available for free (after registration) and thus offers an alternative to fee-based SQL clients like TOAD.