KeepTool 17.0.0 Adds Support for Oracle 23ai Features

KeepTool has released version 17.0.0 of its database utility, introducing new features and enhancements for managing Oracle databases. The latest release specifically addresses new functionalities within Oracle 23ai.

The update provides full support for Oracle 23ai's SQL Domains feature. Users can now view and manage single-column and multi-column domains, as well as flexible and enumeration domains. Tools like Reverse DB and DB Compare have been updated to accommodate these new domain types.

Additionally, KeepTool 17.0.0 includes a new page for visualizing and managing Oracle 23ai Data Mining Models. Basic support for schema annotations has also been implemented, allowing for the maintenance of annotations for tables, views, and columns.

The software features significant enhancements to its SQL Rewrite capabilities. A new 'Rewrite SQL' submenu consolidates existing and new SQL conversion tools. The tool now supports converting SQL code to be compatible with PostgreSQL and MS SQL Server. A new utility also enables the replacement of identifiers based on a CSV file, aiding in tasks such as internationalization of naming conventions.

KeepTool 17.0.0 expands artificial intelligence integration by supporting OpenAI, Claude, Gemini, and Llama platforms. Users can leverage the AI Assistant for generating and editing SQL and PL/SQL code. The update also includes improvements to Data Grid functionalities, such as excluding primary key values during row duplication and displaying content for nested table columns.