Oracle 19c significantly expands JSON capabilities with new functions like JSON_MERGEPATCH , enhancements to JSON_OBJECT , and the ability to map JSON data directly to SQL object types.
Oracle Database 19c is a long-term support release that introduces several advanced SQL and PL/SQL features designed to automate performance tuning, enhance data management, and simplify application development. Core SQL and Development Enhancements oracle sql 19c pdf new
To prevent performance drops due to stale data, the database now gathers essential statistics dynamically during conventional DML (Data Manipulation Language) operations. Oracle 19c significantly expands JSON capabilities with new
For deep dives into these features, you can download the following official guides directly from the Oracle Help Center : My favorite top 10 new features in Oracle database 19c enhancements to JSON_OBJECT