8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Oracle SQL and PL/SQL Enhancements in Oracle Database 19c
This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 19c.
SQL Articles.
- GeoJSON Data Support in Oracle Database 19c
- JSON Support Enhancements in Oracle Database 19c
- JSON_MERGEPATCH in Oracle Database 19c
- JSON_OBJECT Enhancements in Oracle Database 19c
- JSON_SERIALIZE in Oracle Database 19c
- LISTAGG DISTINCT in Oracle Database 19c
- Mapping of JSON Data To and From SQL Object Types in Oracle Database 19c
- Materialized View Support for Queries Containing JSON_TABLE in Oracle Database 19c
- SQL NESTED Clause Instead of JSON_TABLE in Oracle Database 19c
- SQL Quarantine in Oracle Database 19c
PL/SQL Articles.
There were few PL/SQL new features in the original release of Oracle 19c, but some 21c features were back-ported to 19c.
- DBMS_CLOUD : Installation on 19c and 21c On-Prem Databases
- DBMS_CLOUD Package
- DBMS_XPLAN : Compare Execution Plans in Oracle Database 19c and 21c (COMPARE_PLANS, COMPARE_CURSORS and COMPARE_EXPLAIN)
For more information see:
Hope this helps. Regards Tim...