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.
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.
SQL Developer is written completely in Java. It can be run on every platform supporting Java 1.4 or higher.
SQL Developer comes with English and German UI.
Unicode is supported for queries, scripts, data retrieval and file I/O.
Open multiple connections simultaneously to various databases.
Database drivers can be assigned on the fly.
Arrange your workbench components as you like it by using Drag and Drop!
Manage your frequently used statements with the integrated bookmark repository and the statement history.
Adaptive syntax highlighting for the different SQL dialects supports you while coding.
Keyword lookup in the editor gives you access to the complete set of keywords for the active database connection.
Long SQL scripts can be run against any database.
Use the Diagram Editor to visualize tables, views and their relations and dependencies.
Copy data from your spreadsheet application and paste it directly into a database table.
Export your data as SQL Script, as XML or in CSV format.
Printing support in all source and diagram editors.