SQL Developer
History of Changes
Version 2.0.0
- Complete technical redesign.
- Refactored dialog for opening connections:
- Detailed driver info for each connector plugin.
- Direct access to class path configuration.
- Optional user defined name for all connections.
- Basic connector plugin now allows flexible definition of attributes
and retrieves available arguments supported by the driver.
- Oracle connector plugin now allows to connect as SYSDBA or SYSOPER.
- Unicode support for file I/O.
- Menu with recently opened connections added.
- Tabbed bar added for easy switching between windows.
- Exported keys information for tables in database navigator.
- Basic extension for catalog and schema comparison added.
- Basic extension for dissolving object depencies added.
- New diagram editor with zoom, automatic layout and SVG support.
- Extended quick browse for simple creation of complex joined queries.
- Microsoft SQL Server enhancements:
- Microsoft SQL Server connector added.
- Process viewer extension implemented.
- Server monitor extension implemented.
- Remote command shell extension added.
- MySQL enhancements:
- Process viewer extension implemented.
- Oracle enhancements:
- Filter for sessions extension added.
- Jobs extension added.
- Oracle Text (interMedia) extension added.
- Tablespace usage information in database navigator.
- User roles and privileges in database navigator.
- Unique key constraint columns in database navigator.
- Segments information for various objects.
- Added missing columns clause in alter trigger function.
- New database connector for Ingres.
- New database connector for Firebird.
- New database connector for Mckoi SQL Database.
- New database connector for Mimer SQL.
- New database connector for PostgreSQL.
- The GO command is now recognized as a statement terminator in SQL script editor.
- Echo output option for commands in SQL script editor.
- Added support for multiple result sets in SQL script editor.
- New find and replace text dialog with regular expressions.
- Clob viewer supports text search, XML syntax highlighting and XML formatting.
- Blob image viewer now supports zooming and allows to copy the displayed image to clipboard.
- Several minor improvements and bug fixes.
Version 1.16
- Window position is no longer stored for minimized or maximized state.
Version 1.15
- Command termintors in SQL Script editor (; or /) can now be turned on and off.
- Bug fix for blob viewer scrolling.
Version 1.14
- Single SQL Editor only executes the selected range of a query if a
selection exists.
- Editor syntax highlighting colors can now be configured in the
properties dialog.
- DDL extraction of table primary keys implemented.
- DDL extraction of users and table constraints for Oracle implemented.
- SQL Script Editor: Improved parser and single step execution implemented,
bug fix for execute command which often started at wrong position.
- Extended Windows PLAF is no longer installed on non-Windows machines as
it does only work on Windows OS.
- Image option for blob viewer implemented. Blobs containing images can be
viewed within the application. Supported formats: JPEG, GIF and PNG.
- Initial connection info in output window.
- DDL extraction of indices for Oracle implemented.
- DDL extraction of tablespaces for Oracle implemented.
- Display of blob objects in query result sets.
Version 1.13
- New installer to provide JRE 1.4 compatibility for installation.
- First preview of Diagram Editor implemented to visualize tables and relations.
- Display of clob objects in query result sets.
- Dialog resize bug patched for Linux JVMs (Dialogs are always resizable now).
- DDL extraction with multiple selection implemented.
- DDL extraction of sequences for Oracle implemented.
- DDL extraction of views for Access implemented.
- Foreign key indentification for Access implemented.
- Sessions extension for Oracle implemented. The window shows all database
sessions and their SQL statements. The user can also kill sessions from there.
- Schema filter for Oracle implemented. A schema is only shown in the database
navigator if the user has access to at least one object of that schema.
- ODBC connection component now provides a list of available data source names
from the ODBC.ini file.
- Class path order for dynamic driver loading can be configured in the
properties dialog.
Version 1.12
- JRE 1.4 compatibility. (Fixed some glitches in syntax highlighting and word
completion)
- Online help.
- Tip of the day.
- Drag and drop support for database object identifiers from the Database
Navigator into editor windows.
- COUNT(*) function in Single SQL Editor now supports SELECT, UPDATE and DELETE
statements.
- Show Plan extension for SQL Server implemented.
- Drop support for Oracle constraints and table columns implemented.
- Foreign key constraints now show the referenced table in Oracle.
- Bug in Stored Procedure Editor for Oracle fixed. (Carriage return line
separators caused an error on Windows)
Version 1.11
- Explain Plan extension for Oracle implemented.
- Visualization of Oracle objects Roles, Privileges and Snapshots implemented.
- Bug in Single SQL Editor LOB (BLOB/CLOB) display fixed.
Version 1.10
- Drop support for Oracle objects Package, Package Body and Sequence
implemented.
Version 1.09
- Bugs in connection components for MySQL and PointBase fixed
(AbstractMethodError).
- Stored Program Editor with error output for Oracle.
- Visualization of running queries in Single SQL Editor.
- Display of 'first fetch time' after query execution in Single SQL Editor.
Version 1.08
- Oracle connection component automatically selects the first TNSNames entry
after changing the TNSNAMES.ORA location (sometimes the list was empty).
- A ClassNotFoundException while driver initialization is now displayed with the
driver's name and a short note how to solve the problem.
Version 1.07
- Oracle objects data files and rollback segments implemented.
- Warning message when closing editor windows with unsaved content.
- 'Apply' function in properties dialog.
- Preview for Look and Feel switch implemented.
- Bug in context menu on Solaris fixed.
- The about dialog.
- Support of Oracle sequences and tablespaces.
- 'Copy identifier' function in navigator tree implemented.
- Oracle TNSNAMES.ORA is now configurable in connection component.
- Connection profile is now splitted for users and stored in the user home
directory.
- DB2/OS390 object sequence implemented.
- Data export supports optional virtual auto increment fields.
- New document windows are opened cascaded.
- Base functions for Cloudscape implemented.
- Data export supports further standard date formats.
Version 1.06
- Support of multiline strings in single quoted literals.
- Current catalog is marked with CURRENT.
- Syntax support for PointBase, ODBC (Jet) and MySQL implemented.
- Support for alteration of Access views.
- Focus bug in navigator tree fixed.
- Header with tooltip in Single Editor result set display.
- Table column widths adjustment in Single Editor result set display.
(three variants).
Previous versions
- Simple find and replace function in editors.
- Support for saving output documents.
- Connection control commands added to navigator tree context menu.
- Data export with multiple output formats.
- Visualization of standard class path in properties dialog.
- Dynamic driver loading.
- Properties dialog page for class path configuration.
- Print support.
- Automatic indentation in editor.
- Properties dialog page for editor configuration.