SQL Developer - Features

Features

Major features of SQL Developer

This page shows the major features of SQL Developer at a glance. To get a more detailed overview please visit the screenshots section here.

Cross Database

You can connect to every database supporting JDBC access. Additionally ODBC support is provided by the JDBC-ODBC bridge.

The follwing databases have been tested during development: Oracle 8/8i/9i/10g, IBM DB2 (OS 390, Windows), Sybase Adaptive Server Anywhere, Microsoft SQL Server, Microsoft Access, Microsoft Excel, PostgreSQL, PointBase Server, Firebird, MySQL, Mimer SQL, Gupta SQL Base, Ingres, Informix, Mckoi, Cloudscape and HypersonicSQL.

Cross Platform

SQL Developer is written completely in Java. It can be run on every platform supporting Java 1.4 or higher.

Multi Language User Interface

SQL Developer comes with English and German UI.

Full Unicode Support

Unicode is supported for queries, scripts, data retrieval and file I/O.

Multiple Connections

Open multiple connections simultaneously to various databases.

Dynamic Driver Loading

Database drivers can be assigned on the fly.

Dockable Windows

Arrange your workbench components as you like it by using Drag and Drop!

Bookmarks

Manage your frequently used statements with the integrated bookmark repository and the statement history.

Syntax Highlighting

Adaptive syntax highlighting for the different SQL dialects supports you while coding.

Code Completion

Keyword lookup in the editor gives you access to the complete set of keywords for the active database connection.

Script Processing

Long SQL scripts can be run against any database.

Diagram Editor

Use the Diagram Editor to visualize tables, views and their relations and dependencies.

Data Copy & Paste

Copy data from your spreadsheet application and paste it directly into a database table.

Data Export

Export your data as SQL Script, as XML or in CSV format.

Printing

Printing support in all source and diagram editors.