Description

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

6.0.85 13-Mar-25

Database Explorer

Added the ability to save table filter settings to a file
Improved data retrieval behavior using the Open Data in Editor command from the shortcut menu

Code Completion

Improved the parsing of the UNION and EXPRESSIONS syntax constructs
Implemented the suggestions of non-aggregated columns in GROUP BY statements
Added the ssf snippet, which expands to a SELECT * FROM block
Combined Refresh Local Cache and Reset Suggestion Cache in a single Refresh Suggestions option
Added suggestions of a JSON data type for Oracle 21c and the Boolean and Vector data types for Oracle 23ai

SQL Document

Added keyboard shortcuts to duplicate, remove, and join the current line
Added CTRL+/ to comment on a code selection inside a line
Added Ctrl+C and Ctrl+X to copy or cut the entire current line to the clipboard, respectively
Added the ability to use a triple click to select the entire current line
Added highlighting for INSERT statements where the number of values in the VALUES clause does not match the number of columns specified
Added Ctrl+F12 or Ctrl+] to navigate between matching brackets
Improved the general behavior of syntax check
Added highlighting and quick navigation between syntax pairs, including IF … ELSE, BEGIN … END, and CASE WHEN … ELSE … END

Database Diagram

Added support for semi-transparency of table and view blocks
Added support for semi-transparency of containers
Added Clear Waypoints to remove all waypoints manually created for a selected relation
Introduced a linear zoom factor and an overhauled diagram skins
Added Select All Relations

Schema Compare

Added Show Ignored Differences, which can be turned on on the General page of the Options > Schema Comparison window
Added Save Command Line to the Comparison Report wizard
Added a visual Object Filter
Added support for filtering objects from the command line
Added Alt+Down Arrow to navigate to the subsequent difference

Data Compare

Added Ignore internal spaces to be applied to the (N)CHAR, (N)VARCHAR2, (N)CLOB, and LONG columns
Added Ignore computed columns to the New Data Comparison wizard
Added Save Command Line to the Comparison Report wizard
Added Hide empty columns to the Data Differences grid
Added the Issues page to the Data Synchronization Wizard to configure handling of NULL/NOT NULL conflicts during synchronization

Data Generator

Added support for FName and LName masks to represent first names and last names, respectively
Expanded the list of keyboard shortcuts with:
Ctrl+A to select all
Ctrl+Left Arrow to move backward word by word
Ctrl+Right Arrow to move forward word by word
Ctrl+Shift+Left Arrow to select text word by word (backward)
Ctrl+Shift+Right Arrow to select text word by word (forward)
Ctrl+Backspace to delete an entire word
Added the JSON data generator
Added Append timestamp to the file name to the Data Population Wizard

Data Editor

Replaced the Custom AutoFilter window with the advanced Filter Editor window
Added a new command to the shortcut menu - Set Value To > Unique Identifier

Script Generator

Added a new option to enclose identifiers within square brackets
Added Include DML triggers when using the Generate Script AS feature

Data Reports

Adapted the Data Report Wizard for the 4K resolution

Pivot Table

Upgraded Chart Designer to a new advanced version

Query Profiler

Improved the display of estimated and actual query execution plans

Query history

Redesigned Query History with a new toolbar featuring an improved range selection and the Clear option for deleting query history

Other improvements

Enhanced an algorithm to create database projects.
Added Tab layout, Show tabs in multiple rows, and Close tabs with middle-click to the Tabs and Windows page in the Options > Environment window
Added new options to determine the order of opening new document tabs
Added the Copy Data As > CSV command to the shortcut menu to export data directly from the grid to CSV
Integrated SQL Formatter into all commercial editions of dbForge tools for Oracle
Added a new option that drops the destination object during object duplication
Added Sort Ascending, Sort Descending, and Sort by Title in Snippets Manager
Improved the search-and-filtering algorithm for the options available in formatting profiles
Added the ability to search for option names in the Options window
Optimized the installation process for 32-bit executable modules alongside the Studio
Added the ability to work with database snapshots in the Express edition

User-reported and internal bug fixes

Improved text display in the DBMS Output window (T318458, #57902, #161183)
Added support for parsing At Time Zone in variable assignment expressions (#158552)
Fixed an issue where editing block selections caused the loss of focus in documents (#141247)
Fixed an issue with adding a large number of files to a project (#112546)
Added support for parsing the AS keyword after the 'json_table' function in the FROM clause (p132819)
Introduced capability to interpret Oracle Numeric Data Types as numerical values (#146728)
Added support for the UNSPECIFIED option in the INMEMORY_COMPRESSION attribute (#149960)
Fixed the ER-Object reference not set to an instance of an object error (#136696)
Resolved a formatting issue (#158833, #151464, #158212, #158287)
Added support for the ACCESSIBLE BY clause (#158191)
Adjusted the sorting of the Update of columns list in the Trigger Editor based on the Checked status (#187856)
Fixed an issue that occurred when renaming a table after closing the Database Diagram window (#158931)
Fixed an issue that occurred when describing objects in the Database Diagram (#152629)
Improved the display of controls in the Table Editor on the Columns tab (#149552)
Fixed an issue with restoring documents and certain application settings after upgrading to a new version (#146727)
Improved open document tab management, added customization options, and fixed new tab positioning issues (#147392)
Fixed syntax highlighting for string literals in SQL expressions (#147850)
Fixed the Data Export Wizard behavior when saving folders for output in different file formats (#49449)
Fixed an issue with entering values for dynamic SQL parameters of the DATE data type, now allowing time input (p20552)
Improved .sql file saving behavior to prevent the creation of unnecessary .sql.design files (T314455)
Resolved syntax support issues for certain SQL and PL/SQL expressions (#168278)
Fixed a data retrieval issue in Paginal mode when the result set includes unnamed columns (#149461)
Enhanced data filtering capabilities in Data Editor through the integration of a new Filter Editor (#61704)
Fixed the design of application settings pages in the Options window to ensure proper scaling across different DPI settings (T274777)
Resolved an issue causing the truncation of milliseconds in TIMESTAMP(6) WITH TIME ZONE values (#132855)
Resolved an issue encountered when handling NESTED tables in Documenter (#115789)
Fixed an issue occurring on the Mapping page in Data Compare (#105232)
Resolved an issue with connecting to a server running version 19.24 (#160361, #162602, #167112, #174421, #184648, #187861)
Added the ability to ignore system-generated VIRTUAL INVISIBLE columns in Schema Compare (p141424)
Implemented processing for a cyclic dependency case involving identical object names in the source and target in Schema Compare(#152668)

Additional Information