dbForge Studio for Oracle v4.5 release notes

Last modified: March 18, 2025

General improvements

• Added support for Linux and macOS via CrossOver

Improvements to the Code Completion functionality

• 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

Improvements to the Data Compare functionality

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

Improvements to the Data Generator functionality

• Added the /schemaexport and /schemaimport switches for command-line operations

Improvements to the Documenter functionality

• Added support for the Memory Table property
• Added ValidityPeriod for tables

Improvements to the Schema Compare and Table Designer functionality

• Improved the behavior of table columns reordering