Released: Mar 16, 2023

V4.5.21 での更新項目

機能

• Added support for Apple macOS and Linux via CrossOver.
• Added support for the following statements:
  • DROP FLASHBACK ARCHIVE.
  • CREATE RESTORE POINT.
  • DROP RESTORE POINT.
  • SET ROLE.
  • CREATE FLASHBACK ARCHIVE.
  • RENAME.
  • SET CONSTRAINT(s).
  • FLASHBACK TABLE.
  • TRUNCATE CLUSTER.
  • EXPLAIN PLAN.
• Added support for the following SQL*Plus commands:
  • ACCEPT.
  • DEFINE.
  • REMARK.
  • CONNECT.
  • EXIT.
  • PROMPT.
  • VARIABLE.
• Extended support for SELECT statement by adding support for the following clauses and sub-clauses:
  • row_pattern_clause.
  • hierarchies_clause.
  • window_clause.
  • flashback_query_clause (extended).
  • modify_external_table_properties.
  • LATERAL Inline Views.
• Extended support for INSERT statement by adding support for the sub-query factoring clause.
• Added Ignore IDENTITY column option for data comparison and synchronization.
• Added '/schemaexport' and '/schemaimport' switches for command-line operations.
• Data Viewer can now view large LOBs.
• Added support for 'Memory Table' property.
• Added 'ValidityPeriod' for tables.
• Improved error diagnostics in Schema Compare.
• Improved generation of 'PCTFREE' property synchronization script in Schema Compare.
• Improved behavior when reordering table columns.
• Improved memory handling when viewing large sets of data in Paginal Mode.
• Improved behavior of 'Include physical attributes' option for unique keys in Schema Export.
• Enhanced Database Explorer with support for displaying DML triggers created in other schemas.
• Improved behavior of 'Include database name in script' option when using templates in Data Export.
• Improved behavior of 'Generate comments in the script' option in Schema Export.
• Implemented actual values of sequences in data synchronization script.

不具合の修正

• Resolved an issue with the synchronization between a column and a sequence.
• Resolved an issue causing the application to crash upon closing the Trigger editor.
• Fixed an error that occurred when generating a script for columns with DEFAULT ON NULL.
• Resolved an issue with manual product activation.
• Fixed a bug causing the application to crash upon launch.
• Fixed a bug in Master-Detail Browser.
• Resolved an issue with the generation of the synchronization script when the 'Default value ON NULL' option is enabled in Table Editor.
• Fixed the highlighting of built-in functions.
• Fixed an issue with the formatting of packages.
• Fixed an issue with the formatting of the AT TIME ZONE expression.
• Fixed a bug that occurred when describing partitions in Schema Compare.
• Fixed a bug that occurred when refreshing Database Explorer.
• Fixed an issue with the formatting of the subquery factoring clauses.
• Resolved an issue causing the application to freeze during package formatting.
• Fixed an error with importing data from Excel.
• Fixed a bug that occurred when exporting data from the results grid to Excel.
• Fixed an issue with getting the value of an array element in the Debugging mode.
• Fixed an issue with incorrect case selection when formatting variables.
• Fixed a bug that occurred when generating DDL triggers.
• Resolved an issue where a part of the script was mistakenly included in the TODO comment while formatting.
• Fixed a number of issues that occurred when working with queries containing aggregate functions in Query Builder.
• Fixed an error that occurred when attempting to save a schema comparison project with a name that exceeds system limits.