Released: Mar 13, 2025

V6.0.85 での更新項目

機能

• 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
  • 'Ignore internal spaces' can now 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.
  • Improved text display in the DBMS Output window.
  • Added support for parsing At Time Zone in variable assignment expressions.
  • Added support for parsing the AS keyword after the 'json_table' function in the FROM clause.
  • Introduced the capability to interpret Oracle Numeric Data Types as numerical values.
  • Added support for the UNSPECIFIED option in the INMEMORY_COMPRESSION attribute.
  • Added support for the ACCESSIBLE BY clause.
  • Adjusted the sorting of the Update of columns list in the Trigger Editor based on the Checked status.
  • Improved the display of controls in the Table Editor on the Columns tab.
  • Improved open document tab management, added customization options, and fixed new tab positioning issues.
  • Improved .sql file saving behavior to prevent the creation of unnecessary .sql.design files.
  • Enhanced data filtering capabilities in Data Editor through the integration of a new Filter Editor.
  • Added the ability to ignore system-generated VIRTUAL INVISIBLE columns in Schema Compare.
  • Implemented processing for a cyclic dependency case involving identical object names in the source and target in Schema Compare.

不具合の修正

• Fixed an issue where editing block selections caused the loss of focus in documents.
• Fixed an issue with adding a large number of files to a project.
• Fixed the ER-Object reference not set to an instance of an object error.
• Resolved a formatting issue.
• Fixed an issue that occurred when renaming a table after closing the Database Diagram window.
• Fixed an issue that occurred when describing objects in the Database Diagram.
• Fixed an issue with restoring documents and certain application settings after upgrading to a new version.
• Fixed syntax highlighting for string literals in SQL expressions.
• Fixed the Data Export Wizard behavior when saving folders for output in different file formats.
• Fixed an issue with entering values for dynamic SQL parameters of the DATE data type, now allowing time input.
• Resolved syntax support issues for certain SQL and PL/SQL expressions.
• Fixed a data retrieval issue in Paginal mode when the result set includes unnamed columns.
• Fixed the design of application settings pages in the Options window to ensure proper scaling across different DPI settings.
• Resolved an issue causing the truncation of milliseconds in TIMESTAMP(6) WITH TIME ZONE values.
• Resolved an issue encountered when handling NESTED tables in Documenter.
• Fixed an issue occurring on the Mapping page in Data Compare.
• Resolved an issue with connecting to a server running version 19.24.