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.