Devart dbForge Studio for Oracle Enterprise Edition v4.5.21
Devart dbForge Studio for Oracle Enterprise Edition v4.5.21
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 Oracle IDE allows synchronizing data between different Oracle servers and automating schema change management process during development. dbForge Oracle GUI features powerful functionality 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
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
Object search
4.5.21 16-Mar-23
Improvements
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 (D89273)
Resolved an issue causing the application to crash upon closing the Trigger editor (D102662)
Fixed an error that occurred when generating a script for columns with DEFAULT ON NULL (D110980)
Resolved an issue with manual product activation (D99323)
Fixed a bug causing the application to crash upon launch (D113391)
Improved Data Viewer in Data Compare to allow for viewing large LOBs (D19502)
Improved memory handling when viewing large sets of data in the Paginal Mode of the Data Editor (D98727)
Improved the behavior of the 'Include physical attributes' option for unique keys in Schema Export (D93066)
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 (D92710)
Improved the behavior of the 'Generate comments in the script' option in Schema Export (D92598)
Improved the generation of the PCTFREE property synchronization script in Schema Compare (D89274)
Fixed a bug in Master-Detail Browser (D105719)
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 (D110029, D109918)
Fixed an issue with the formatting of packages (D106666)
Fixed an issue with the formatting of the AT TIME ZONE expression (D106766)
Fixed a bug that occurred when describing partitions in Schema Compare (D96302)
Fixed a bug that occurred when refreshing Database Explorer (D94785, D94784)
Fixed an issue with the formatting of the subquery factoring clauses (D81274)
Resolved an issue causing the application to freeze during package formatting (D81274)
Fixed an error with importing data from Excel (D81112)
Fixed a bug that occurred when exporting data from the results grid to Excel (D103683)
Fixed an issue with getting the value of an array element in the Debugging mode (D80548)
Fixed an issue with incorrect case selection when formatting variables (D100932)
Fixed a bug that occurred when generating DDL triggers (D96143)
Resolved an issue where a part of the script was mistakenly included in the TODO comment while formatting (D95810)
Fixed a number of issues that occurred when working with queries containing aggregate functions in Query Builder (D88397)
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
Improvements
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 (D89273)
Resolved an issue causing the application to crash upon closing the Trigger editor (D102662)
Fixed an error that occurred when generating a script for columns with DEFAULT ON NULL (D110980)
Resolved an issue with manual product activation (D99323)
Fixed a bug causing the application to crash upon launch (D113391)
Improved Data Viewer in Data Compare to allow for viewing large LOBs (D19502)
Improved memory handling when viewing large sets of data in the Paginal Mode of the Data Editor (D98727)
Improved the behavior of the 'Include physical attributes' option for unique keys in Schema Export (D93066)
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 (D92710)
Improved the behavior of the 'Generate comments in the script' option in Schema Export (D92598)
Improved the generation of the PCTFREE property synchronization script in Schema Compare (D89274)
Fixed a bug in Master-Detail Browser (D105719)
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 (D110029, D109918)
Fixed an issue with the formatting of packages (D106666)
Fixed an issue with the formatting of the AT TIME ZONE expression (D106766)
Fixed a bug that occurred when describing partitions in Schema Compare (D96302)
Fixed a bug that occurred when refreshing Database Explorer (D94785, D94784)
Fixed an issue with the formatting of the subquery factoring clauses (D81274)
Resolved an issue causing the application to freeze during package formatting (D81274)
Fixed an error with importing data from Excel (D81112)
Fixed a bug that occurred when exporting data from the results grid to Excel (D103683)
Fixed an issue with getting the value of an array element in the Debugging mode (D80548)
Fixed an issue with incorrect case selection when formatting variables (D100932)
Fixed a bug that occurred when generating DDL triggers (D96143)
Resolved an issue where a part of the script was mistakenly included in the TODO comment while formatting (D95810)
Fixed a number of issues that occurred when working with queries containing aggregate functions in Query Builder (D88397)
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
Only for V.I.P
Warning! You are not allowed to view this text.