dbForge Studio for Oracle Express

dbForge Studio for Oracle Express is a free software that provides basic functionality for working with schema objects, user accounts, SQL scripts, and queries.

Key Features:

- PL SQL editor with syntax highlight, bookmarks, and text search

- Context-sensitive code completion (partial support)

- Quick information about schema objects (partial support)

- Parameter information for stored routines (partial support)

- Visual Query Builder (the number of tables is limited to 3, sub-queries are not supported)

- Visual editors for schema objects

- Database Diagram (the number of schema objects on a diagram in the Express edition is limited to 10)

- Object Viewer window

- Security Manager

- Session Manager

- Event Monitor

- Data import and data export (CSV format has no restrictions for data export and import, for other formats only first 50 rows are processed. User templates are not supported)

- Schema export and import (dump) (It does not support schema export projects, auto-deletion of old schema export files, compression, and schema export files larger than 1MB)

- Data editor with in-place filtering, grouping, and sorting

- Multiple database connections in Database Explorer window