Oracle 19c

19c, is available

19c may also be deployed on Oracle Engineered Systems (e.g. Exadata) on-prem, on Oracle (public) Cloud or (private) Cloud at Customer.

Some (imho) interesting new or deprecated/removed features

json_mergepatch applies one or more changes to multiple JSON documents with a single statement.

distinct for listagg

SQL Quarantine

Hybrid partitioned tables which extend Oracle partitioning.

Automated installation, configuration and patching

DBCA commands createDuplicateDB, relocatePDB, createFromRemotePDB.

catpcat.sql runs catalog.sql and catproc.sql in parallel to speed up the creation of a database.

Table macros (scalar macros with 21c)

Init parameter o7_dictionary_accessibility was removed.