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
* PL/SQL formatter (partial support)
* 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)
* Query history (the history is saved for the last 3 days only)
* 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
* Duplicate Object
* 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
Comments