dbForge Studio for Oracle

What's new in this version:

dbForge Studio for Oracle Enterprise 4.6.36
- Fixed the error that occurred when saving data to the clipboard (Ctrl+C) in the Data Editor


dbForge Studio for Oracle Enterprise 4.6.35
Fixed:
- Fixed an issue that occurred at the application startup
- Fixed an issue that occurred when synchronizing schemas containing Index Organized Tables
- Fixed an issue with exporting numeric data types to MySQL and MariaDB using ODBC
- Fixed an issue with converting the numeric data type Number to varchar(32) when exporting data from Oracle to MariaDB using ODBC
- Fixed the "Failed to convert parameter value from a DateTimeOffset to a DateTime." error that occurred when exporting data from Oracle to MariaDB using ODBC
- Resolved the application crash that occurred when an SQL document contained numerous UNIONs


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