Previous Next

Oracle SQL Developer Alternative

Check out the features of two powerful tools: dbForge Studio for Oracle and its analogue - Oracle SQL Developer. Comparative features matrix (below) describes products capabilities. You can find the detailed features list of dbForge Studio for Oracle on the Features page.


dbForge Studio*

Oracle SQL Developer*

Oracle Database Connectivity
Support for Oracle versions from 8i to 12c Yes Yes
Ability to use several Oracle Homes in single application Yes Yes
Instant Client support Yes Yes
Optional direct access mode for establishing connections without Oracle client software Yes Yes
Working with Oracle on Amazon RDS Yes Yes
Unicode support Yes Yes
Connection color Yes Yes
Proxy connection None Yes
OS authentication Yes Yes
Kerberos authentication None Yes
Cloud connections None Yes
Administration and Maintenance
Comprehensive Security Manager to administer user accounts and privileges Yes Yes
Session manager for monitoring active Oracle server connections and tracing user sessions Yes Yes
Event Monitor for monitoring Oracle database alerts and pipe messages Yes None
Data Analysis
Display table data representing Parent-Child dependencies (Master-Detail Browser) Yes None
Data report generation wizard Yes None
Data report designer Yes None
Pivot table designer Yes None
Chart building wizard Yes Yes
Data search on a live database Yes Yes
Automate report generation and distribution (command line support) Yes None
Data Editor
Asynchronous data fetch with ability to cancel the operation Yes Yes
Batch table update mode when changes are accumulated and applied explicitly Yes None
Copying data with column headers for quick pasting to spreadsheet Yes None
Custom data filters of any complexity Yes None
Data Viewer window for browsing images, rtf, and binary cell values Yes None
Date time editor with visual interface Yes Yes
Foreign key lookup editor for easy editing of fields referencing other tables Yes None
Free copying of any block of data to clipboard Yes None
Full-text search (Ctrl+F) in data grid Yes Yes
Graphical card view Yes Yes
Grouping by arbitrary columns Yes Yes
Incremental search (Ctrl+I) through data grid Yes None
Large objects (LOB) editor Yes Yes
Multi-table query result set editing Yes Yes
Paginal data browsing for large result sets Yes None
Printing of data Yes Yes
Quick filter feature available for each data cell Yes Yes
Record numbering option Yes Yes
Read-only state indication Yes None
Report, chart, and pivot building directly from data editor Yes None
Server-side sorting and filtering to help dealing with large data sets Yes None
Visible columns picking dialog box Yes Yes
Editing of multiple execution results of one script on separate tabs Yes None
Support of various ADT in a separate editor Yes None
Database Explorer
Multiple database connections allowed Yes None
Asynchronous connecting to server with ability to cancel the operation Yes Yes
Browse and navigate through objects Yes Yes
Detailed object properties and data browsing in Object Viewer window Yes Yes
Dependency tree browsing for each object Yes None
Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc. Yes None
Customizable DDL generation via wizard Yes Yes
'Send To' command for quick sending of tables to Query Builder, Data Report, and other tools Yes None
Quick access to object privileges (GRANT) from the popup menu Yes None
Multi-selection for batch operations on objects Yes Yes
Database navigation history Yes None
Database Projects
New project wizard with import from an existing database Yes None
Project Explorer window for managing project files Yes None
Schema View window for browsing logical project structure Yes None
Project export into one of multiple scripts Yes None
Multiple build configurations Yes None
Single-click project deployment on the server Yes None
Workspace saving Yes None
Oracle Debugger
PL/SQL code debugging Yes Yes
Script debugging Yes Yes
Step Into, Step Over, and Step Out commands for step-by-step execution Yes Yes
Breakpoints support for procedures, functions, triggers, and scripts Yes Yes
Breakpoints window Yes Yes
Call Stack window with navigation Yes Yes
Watches window for variable evaluation Yes Yes
Data export to:
CSV Yes Yes
XML Yes Yes
Text Yes Yes
XLS Yes Yes
XLSX Yes Yes
PDF Yes Yes
DBF Yes None
HTML Yes Yes
RTF Yes None
MDB (Access) Yes None
ODBC Yes None
SQL Yes Yes
Loader None Yes
Export data from multiple tables at once Yes Yes
Export data from command line interface Yes None
Data import from:
CSV Yes Yes
XML Yes Yes
Text Yes Yes
XLS Yes Yes
XLSX Yes Yes
DBF Yes None
MDB (Access) Yes None
ODBC Yes None
Import data from command line interface Yes None
Templates for exporting and importing Yes None
Table Designer
Flat table editor Yes Yes
Convenient editor for foreign keys Yes Yes
Partitioning support Yes Yes
Full-text search on the column grid Yes Yes
Schema changes can be viewed before updating database Yes Yes
Heuristics helps define data type of new columns Yes None
Object Editor
Create and manipulate database objects through graphical interface Yes Yes
Visual editors for following schema object types: Yes Yes
Database link Yes Yes
Cluster Yes None
Check constraint Yes Yes
Foreign key Yes Yes
Index Yes Yes
Materialized view Yes Yes
Materialized view log Yes Yes
Package Yes Yes
Sequence Yes Yes
Stored function Yes Yes
Stored procedure Yes Yes
Synonym Yes Yes
Table Yes Yes
Trigger Yes Yes
Unique key Yes Yes
User type Yes None
View Yes Yes
XML schema Yes None
Undo option for object editor Yes None
Ability to browse schema objects in a single editor (pin document) Yes Yes
Schema object search based on a variety of parameters Yes Yes
Oracle Export and Import Utilities Support
Support for Exp and Imp utilities Yes None
Wizards for export and import procedure setup Yes None
Quick access from Database Explorer Yes None
Visual Query Builder
The state-of-art diagram with zooming and keyboard support Yes Yes
Preview and printing of the diagram Yes None
Visual addition of sub-queries to any part of the main query Yes Yes
Query outline (displayed in Document Outline window) Yes None
Visual editing of sub-queries Yes Yes
Expression builder for creating complex conditions Yes None
Copy/Paste for tables on the diagram Yes Yes
Undo/Redo support Yes None
Visual Query Profiler
PL/SQL profiling to detect code performance bottlenecks Yes None
Visual SQL explain plan Yes Yes
Session statistics displayed in a UI Yes None
Plan of the query displayed in the tree view for easy review Yes Yes
Profiling history that can be saved for further analysis Yes None
Compare profiling results feature with differences highlight Yes None
Profiling results printing Yes None
Schema comparison and synchronization
Comparing and synchronizing data in databases of virtually any size Yes None
Comparison of tables, views, materialized views, and custom queries Yes None
Custom comparison keys support Yes None
Option for BLOB data comparison Yes None
Comparison results filtering Yes None
Data synchronization script generation Yes None
Per record viewing of data differences Yes None
Excluding tables and records from synchronization Yes None
Saving and loading of comparison settings Yes None
Command line interface for data comparison and synchronization Yes None
Generating accurate comparison reports in HTML and Excel formats Yes None
You can learn the full feature list for data comparison tool. Yes None
Schema Export and Import
Comprehensive Oracle database schema export and import wizards Yes Yes
Export of Oracle object definition schemas as well as its data Yes Yes
Reverse engineer objects DDL including roles, permissions to recreate objects in a different db/schema Yes None
Schema export projects to save settings for future use Yes None
Zip compression for export output files Yes Yes
Command line support for automating schema export Yes None
Error and status logging Yes None
SQL Editing and Execution
Automatic SQL syntax check Yes Yes
Code outlining with support of user-defined collapsing regions Yes None
Code Snippets Yes Yes
Customizable SQL formatting and code beautifier Yes Yes
Execute current statement Yes Yes
Wildcard expansion Yes None
Quick information about schema objects Yes None
Parameter information for stored routines Yes None
Quick access to favorite templates from SQL editor Yes None
SQL editor with syntax coloring, bookmarks, and text searching Yes Yes
Document Outline window for quick navigation through large scripts Yes None
Execution of scripts, selected SQL fragments, and statements Yes None
One step access to a schema object editor from code (go to definition) Yes None
Executed SQL history window for the document Yes Yes
Code Completion
Name suggestions for major objects Yes Yes
Name suggestions for advanced objects Yes None
Smart filtering in the suggestion list Yes None
Context-sensitive suggestion of keywords Yes None
Database context detection Yes None
Semi-transparent view of the suggestion box Yes None
Individual word recognition in CamelCase identifiers Yes None
Column picker for quick list building Yes None
JOIN clause auto generation Yes Yes
Auto-generation of table aliases Yes None
Database Design
Visual Database Designer Yes Yes
Visualization of tables, views, stored procedures Yes Yes
Easy access to database objects for viewing their properties, editing, retrieving data, executing stored routines, etc. Yes Yes
Support for IDEF1X and IE notations Yes Yes
Customizable diagram look and feel with skin support Yes None
Smart ER Diagram layout Yes None
Diagram export to different image formats Yes Yes
Searching database objects on diagram Yes Yes
Organizing diagram shapes with containers Yes Yes
Customizable diagram printing with a rich set of options Yes None
Optional displaying of table constraints, indexes, and triggers Yes None
Integration with Document Outline window Yes None
Diagram navigation with Diagram Overview window Yes Yes
Notes for adding your comments to the diagram Yes Yes
User Interface
Start page providing easy access to main product features Yes Yes
Rich user settings Yes Yes
UI skins Yes None
Customizable window layout Yes Yes
Tool windows with 'auto-hide' and 'float' modes Yes Yes
Multiple shortcut schemes with full shortcut customization Yes Yes
Syntax highlight customization Yes Yes
Tabbed groups for documents Yes Yes
Toolbars customization Yes Yes
Wizard for sharing common code standards and templates Yes None

*The table above provides comparison of features of dbForge Studio for Oracle, v3.7 Professional Edition with the similar functionality of Oracle SQL Developer, v4.0.