Contents

dbForge Studio for Oracle v6.0 release notes

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.

Want to Find out More?

• Previous
• Next