IDE for Oracle database development, management, and administration

dbForge Studio for Oracle

dbForge Studio for Oracle

  -  Trial
  • Latest Version

    dbForge Studio for Oracle Enterprise 4.6.15 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows 7 / Windows 8 / Windows 10 / Windows 11

  • User Rating

    Click to vote
  • Author / Product

    Devart / External Link

dbForge Studio for Oracle is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data. This tool allows synchronizing data between different Oracle servers and automating the schema change management process during development. This Oracle database manager has lots of features wrapped into a smooth management Oracle GUI consistent with Microsoft Visual Studio.

PL/SQL Development
Write and format code on the fly, debug procedures, functions, and triggers, optimize query performance and eliminate bottlenecks with: IntelliSense-like, PL/SQL code completion, PL/SQL formatter, Query Profiler, Code snippets, PL/SQL debugger.

Data Modeling and Design
Design Oracle databases visually, build queries in a few clicks, create and edit database objects with: Visual query builder, Visual database designer, Database diagrams, Visual editors for schema objects, Table designer, Database projects.

Change Management and Data Manipulation
Migrate schemas and data between databases, manage data and schema diffs with: Data import and data export, Schema export and import (dump), Data comparison and synchronization, Schema comparison, and synchronization. Download dbForge Studio for Oracle for Windows PC today!

Analysis and Data Reporting
Design data reports, charts, pivot tables with parameters, customizable formatting, and calculated summaries. dbForge Studio for Oracle includes the following tools for efficient data reporting and analysis: Data report designer, Pivot tables, Automated data report delivery.

Features and Highlights
  • PL/SQL editor with code completion and navigation
  • Powerful data editor
  • Integrated PL/SQL debugger
  • Data export and data import
  • Database diagrams
  • Schema comparison and synchronization tool
  • Data comparison and synchronization tool
  • Database projects
  • Query builder
  • Reporting and analysis tools
  • Schema Export
  • Visual schema object editors
  • Query profiler
  • Find a database object tool
Note: 30 days trial version. Requires .NET Framework

  • dbForge Studio for Oracle Enterprise 4.6.15 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    dbForge Studio for Oracle Enterprise 4.6.15 Screenshot 1
  • dbForge Studio for Oracle Enterprise 4.6.15 Screenshot 2
  • dbForge Studio for Oracle Enterprise 4.6.15 Screenshot 3
  • dbForge Studio for Oracle Enterprise 4.6.15 Screenshot 4

What's new in this version:

dbForge Studio for Oracle Enterprise 4.6.15
SQL Document and Code Completion:
- Added support for CREATE, ALTER, and DROP VIEW statements
- Added new formatting profiles

Script Generator:
- Added option Include security permissions

User-reported and internal bug fixes:
- Added support for displaying the ANYDATA data type values in the Data Editor
- Fixed an issue with executing the Find in Database Explorer command from the Search window when the Database Explorer window is closed
- Enhanced the mechanism to determine users' DBA privileges and resolved an issue with retrieving the list of objects for Database Explorer
- Supported U'string literals in scripts
- Fixed an issue that occurred when launching the application
- Implemented parsing for the DISTINCT, UNIQUE, and ALL keywords within the parameters of the LISTAGG function
- Fixed the syntax parsing errors in scripts that were causing formatting issues
- Resolved a syntax parsing error in queries involving UNION, which was causing the Studio to crash
- Fixed syntax parsing errors in scripts that were causing issues when using the Generate Script As functionality
- Fixed the recursive resolution of references during script formatting
- Resolved an issue with exporting/importing data to/from Excel
- Enhanced metadata retrieval for stored procedures to avoid excessive memory usage
- Corrected a grammatical error in the warning message regarding dependent objects during schema synchronization
- Fixed an error that occurred during documentation generation


dbForge Studio for Oracle Enterprise 4.5.117
Improved:
- Added connectivity support for Oracle 23c

User-reported and internal bug fixes:
- Fixed an error that occurred when retrieving metadata for schema objects in Documenter
- Refined the conditions for activating the AUTO COMMIT mode button in SQL Document
- Resolved an issue with hints in the Completion List that occurred when invoking a hint before a subquery
- Fixed an issue with data export to Excel
- Fixed the loss of TABLESPACE and STORAGE OPTIONS during the synchronization of tables, indexes, and materialized views
- Resolved an issue with unnecessary indentation being added when formatting queries with the USING clause in a JOIN
- The application runs out of memory when backing up databases containing large objects (> 1GB)
- Poor user interface responsiveness when configuring data generation settings for databases with lots of tables


dbForge Studio for Oracle Enterprise 4.5.21
Improved:
- Added support for Linux and macOS via CrossOver

Code Completion:
- Added support for the DROP FLASHBACK ARCHIVE statement
- Added support for the CREATE RESTORE POINT statement
- Added support for the DROP RESTORE POINT statement
- Added support for the SET ROLE statement
- Added support for the CREATE FLASHBACK ARCHIVE statement
- Added support for the RENAME statement
- Added support for the SET CONSTRAINT(s) statement
- Added support for the FLASHBACK TABLE statement
- Added support for the TRUNCATE CLUSTER statement
- Added support for the EXPLAIN PLAN statement
- Added support for the following SQL*Plus commands: ACCEPT, DEFINE, REMARK, CONNECT, EXIT, PROMPT, and VARIABLE
- Extended support for the SELECT statement by adding support for the following clauses and subclauses: row_pattern_clause, hierarchies_clause, window_clause, flashback_query_clause (extended), modify_external_table_properties, and LATERAL Inline Views
- Extended support for the INSERT statement by adding support for the subquery factoring clause

Data Compare:
- Added the Ignore IDENTITY columns option for data comparison and synchronization
- Added the /schemaexport and /schemaimport switches for command-line operations

Data Generator:
- Added the /schemaexport and /schemaimport switches for command-line operations

Documenter:
- Added support for the Memory Table property
- Added ValidityPeriod for tables

Schema Compare and Table Designer:
- Improved the behavior of table columns reordering

User-reported and internal bug fixes:
- Resolved an issue with the synchronization between a column and a sequence
- Resolved an issue causing the application to crash upon closing the Trigger editor
- Fixed an error that occurred when generating a script for columns with DEFAULT ON NULL
- Resolved an issue with manual product activation
- Fixed a bug causing the application to crash upon launch
- Improved Data Viewer in Data Compare to allow for viewing large LOBs
- Improved memory handling when viewing large sets of data in the Paginal Mode of the Data Editor
- Improved the behavior of the 'Include physical attributes' option for unique keys in Schema Export
- Enhanced Database Explorer with the support for displaying DML triggers created in other schemas (T306811)
- Improved the behavior of the 'Include database name in script' option when using templates in Data Export
- Improved the behavior of the 'Generate comments in the script' option in Schema Export
- Improved the generation of the PCTFREE property synchronization script in Schema Compare
- Fixed a bug in Master-Detail Browser
- Resolved an issue with the generation of the synchronization script when the 'Default value ON NULL' option is enabled in Table Editor (u43214109)
- Fixed the highlighting of built-in functions
- Fixed an issue with the formatting of packages
- Fixed an issue with the formatting of the AT TIME ZONE expression
- Fixed a bug that occurred when describing partitions in Schema Compare
- Fixed a bug that occurred when refreshing Database Explorer
- Fixed an issue with the formatting of the subquery factoring clauses
- Resolved an issue causing the application to freeze during package formatting
- Fixed an error with importing data from Excel
- Fixed a bug that occurred when exporting data from the results grid to Excel
- Fixed an issue with getting the value of an array element in the Debugging mode
- Fixed an issue with incorrect case selection when formatting variables
- Fixed a bug that occurred when generating DDL triggers
- Resolved an issue where a part of the script was mistakenly included in the TODO comment while formatting
- Fixed a number of issues that occurred when working with queries containing aggregate functions in Query Builder
- Fixed an error that occurred when attempting to save a schema comparison project with a name that exceeds system limits
- Improved the error diagnostics in Schema Compare
- Implemented the actual values of sequences in the data synchronization script


dbForge Studio for Oracle Enterprise 4.4.64
Fixed:
- compatibility issues with the latest Windows 11 updates
- an error that occurred when generating a comparison report from the command line


dbForge Studio for Oracle Enterprise 4.4.56
Fixed:
- a problem with launching the Start Page
- syntax error that occurred during script formatting
- an error with losing triggers when rebuilding a table when synchronizing schemes
- an error that occurred when working with the editor in the SQL document


dbForge Studio for Oracle Enterprise 4.4.51
Fixed:
- Fixed an issue that blocked the program from being installed on specific environments due to the shell folder constant expansion failure
- Fixed a critical error that occurred because of the editor cursor initialization failure when running under Microsoft Windows 11 Build 22567 and later
- Fixed a critical error that occurred when painting the main window of the program on high resolution displays
- Resolved an issue that caused the program license reactivation process after the BIOS update to fail


dbForge Studio for Oracle Enterprise 4.4.49
Fixed:
- an error that occurred when formatting a package
- the display of the Invalid Object Manager document in the dark mode
- an unexpected exception that occurred when closing a document that was modified in an external editor
- the behavior of the application installer when checking the version of the .NET Framework
- an issue with comparing objects in Data Compare
- an error that occurred when executing a query
- an issue with retrieving table metadata


dbForge Studio for Oracle Enterprise 4.4.40
Connectivity:
- Added support for Oracle 21c

Code Completion:
- Added support for the SQL*Plus DESCRIBE command

Data Compare:
- Updated the Report Wizard

Schema Compare:
- Added the Ignore MAXVALUE option
- Added the Ignore INCREMENT BY option
- Added the Ignore CACHE option
- Added the Ignore CYCLE option
- Improved the behavior of the Ignore START WITH option
- Drastically improved reports

Documenter:
- Added support for the JSON search index
- Added attribute clustering support

Other improvements:
- Added support for nested tables in Generate Script As
- Expanded the Generate Script As settings with 4 new options: Include COMMIT, Include SET SQLBLANKLINES ON, Include SET DEFINE OFF, and Include NLS parameters for the current session
- Improved the behavior of the Retrieve Data option
- Updated integration with version control systems

User-reported and internal bug fixes:
- Fixed an issue with forced addition of quotes to generated aliases when they are output in lower case
- Added support for the conditional compilation expressions in syntax check
- Added support for PL/SQL declarations in CTE expression syntax
- Added support for the CROSS APPLY operator in the SELECT statement syntax
- Fixed comparison of packages containing a schema name
- Fixed an error that occurred when generating a synchronization script with the PL/SQL blocks
- Fixed an error that occurred when activating the application
- Fixed display of materialized views in Database Explorer
- Fixed an issue with displaying the list of partitions in the table editor in the dark skin mode
- Fixed an issue with displaying relationships between tables in the Database Diagram
- Fixed an issue with accessing the System.Net.Http assembly when starting the application
- Fixed an issue with sending error reports from an application without an installed email client


dbForge Studio for Oracle Enterprise 4.3.99
- The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update
- Fixed a critical error occurred when comparing data


dbForge Studio for Oracle Enterprise 4.3.97
Fixed:
- Issue with editing invalid objects
- Issue with connecting to Oracle 8 using the enabled Unicode option


dbForge Studio for Oracle Enterprise 4.3.93
Fixed:
- Issue with filtering in Database Explorer
- Error when establishing connection in the Direct modе
- Issue with the search operation in the view editor
- Improved processing of the error that occurred when executing cursor scripts
- Improved capabilities for opening a connection for users with limited permissions
- Improved behavior of the context menu on the Constraints tab of the table editor
- Error with the use of virtual columns
- Improved capabilities of work with the SQL*Plus DEFINE command
- Improved behavior of alias renaming for view columns
- Improved application of parameters when executing scripts by using the F5 and F8 commands
- Issue with cell focus in Data Editor
- Issue with parameter recognition during the execution of scripts
- Unexpected exception when importing data from an Excel file
- Error when restoring documents
- Unexpected exception when describing indexes during the generation of documentation
- Added processing of the circular dependency between the calculated column and the function
- Error while loading assemblies
- Mapping reset error during comparison with Custom Query
- Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns
- Data comparison error that occurred when working with BYTE columns
- Fixed processing of errors that occurred as a result of multi-threading
- Issue with using Find and Replace in the object editor
- Issue with procedure text modification during debugging
- Issue with license verification on launch
- Issue with creating JOIN connections in Query Builder
- Added capability to set the time for input parameters of the DATE type in stored procedures
- Error that occurred when opening documents


dbForge Studio for Oracle Enterprise 4.3.34
New features and improvements:
- Activation of the tool via the command-line interface
- Improved working with virtual columns when comparing and synchronizing schemas

User-reported and internal bug fixes:
- Issue with synchronizing unique keys when modifying columns (T321087, T322045)
- Index analysis error when modifying a table (T324838)
- Working with index metadata is corrected
- Error when copying data from Data Editor (T319036, T319061, T319090, T319180, T319304, T320387, T320393, T320831, T321857, T323218)


dbForge Studio for Oracle Enterprise 4.2.34
- Complete server version for Oracle 18 and higher was detected incorrectly
- The 'SQL command not properly ended' error occurred with the delimiter character when executing the WITH clause (T312408)
- Behavior when copying the cell values from Data Editor is improved
- Issue with detecting the difference between tablespaces in constraints is eliminated
- Issue with the correct use of tablespaces in constraints when the Ignore Tablespaces option is enabled is eliminated (T306592)
- Error occurred with describing columns (T304630, T304631)
- A query that left-joined a table that was inner-joined with another table using parentheses to override the default precedence could not be formatted
- Formatting of a broken XLS file when exporting data to EXCEL is fixed
- Quoting when exporting data of the DATE format to EXCEL is improved (T313769)
- An error with closing the SQL document is eliminated


dbForge Studio for Oracle Enterprise 4.2.20
New features and improvements:
- Connectivity support for Oracle 20c is implemented
- New 'Reseed identity column' data sync option is added


dbForge Studio for Oracle Enterprise 4.1.94
Bugs fixed:
- Problem with the same name objects in documenter is fixed
- Problem with syntax highlight in .pkb file is fixed
- Problem with formatting long quoted multiline literals is fixed
- Problem with Hebrew Chars is fixed
- Other minor user reported bugs are fixed


dbForge Studio for Oracle Enterprise 4.1.48
Bugs fixed:
- Problem with lost synchronization script is fixed
- Problems with foreign keys comparing are fixed
- Other minor user reported bugs are fixed


dbForge Studio for Oracle Enterprise 4.1.43

New features and improvements:
- Brand New Application Skins
- Support for Oracle 19c
- AutoCommit Mode ON/OFF
- Improved Schema Comparison Performance
- Transaction Reminder and Execution Notifications

User reported bugs fixed:
- Problem with incorrect temporal table name is fixed
- Problem with wrong message in formatter is fixed
- Problem with ignore collation option is fixed
- Problem with Syntax Check is fixed
- Problem with Generate Fully Qualified Object Name option is fixed
- Problems with describe objects in Data Compare are fixed


dbForge Studio for Oracle Enterprise 4.0
Bugs fixed
- Problem with option "Generate fully qualified object names" is fixed
- Incorrect description of system properties is fixed
- Incorrect description of database object is fixed
- Problems in schema comparison wizard are fixed
- Problem with restoring *.dbd file is fixed
- Materialized view creation issue is fixed
- Data rows addition issue is fixed
- Problems with pressing "Refresh" button in "Breakpoints" window are fixed
- Problem with retrieving data from table is fixed
- Other user reported bugs are fixed