Oracle has continuously evolved its JSON processing capabilities, transitioning from APEX_JSON-based PL/SQL parsing to high-performance, native JSON functions embedded within SQL and PL/SQL.

For SQL, there are new features like data types, aliases for GROUP BY clauses, joins for DELETE and UPDATE statements, IF [NOT] EXISTS DDL clause, and FUZZY_MATCH, PHONIC_ENCODE to mention a few.