With the latest Oracle Database 19c Release Update (RU) 19.28, several key features previously available only in Oracle 23ai are now supported. This update introduces four notable capabilities that enhance developer productivity and simplify database management.
DBMS_DEVELOPER PL/SQL Package
The DBMS_DEVELOPER package offers a faster, more flexible way to retrieve metadata for database objects. Instead of XML, it returns metadata in JSON format, making integration with tools and services easier. It also allows adjusting the level of detail returned, improving performance and control.
IF [NOT] EXISTS Syntax Support
The IF [NOT] EXISTS clause is now supported in DDL operations for creating, altering, and dropping objects. This helps avoid errors when objects already exist or don’t exist, making scripts more reliable and easier to maintain.
Schema Annotations
With schema annotations, developers can attach structured metadata to database objects using simple name-value pairs. These annotations help store business-specific or UI-related information directly within the database, supporting consistency across applications.
SQL Diagnostic Report
The new REPORT_SQL function in DBMS_SQLDIAG generates detailed diagnostic reports in HTML format. These include execution history, non-default settings, optimizer statistics, and index details—making it easier to investigate and resolve SQL performance issues.
Top comments (0)