Professional is an ultimate package for enterprise-level project management that provides the following functionality: database projects framework, database change management with help of database comparison and synchronization tools, complex queries creating, master-detail data browser, data analysis and reporting tools, tasks automation through the command line.
Standard edition extends the Express edition's functionality with Pivot Table Designer, PL/SQL Debugger, Query Profiler, advanced Coding Assistance features, and database search options. Moreover, this edition includes enhanced Query Builder, Data Export/Import features and command-line interface for data reporting.
Express is a free software that provides basic functionality for working with schema objects, user accounts, SQL scripts and queries.
1 The number of tables is limited to 3, sub-queries are not supported.
2 The number of schema objects on a diagram in the Express edition is limited to 10.
3 CSV format has no restrictions for data export and import, for other formats only first 50 rows are processed. User templates are not supported.
4 It does not support schema export projects, auto-deletion of old schema export files, compression, and schema export files larger than 1MB.
* These Oracle versions are not supported in data and schema compare tools.
** TFS and SVN only.