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 21c
This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 21c.
SQL Articles.
- Analytic Function Syntax Enhancements in Oracle Database 21c
- ANY_VALUE Aggregate Function in Oracle Database 21c
- BIT_AND_AGG, BIT_OR_AGG and BIT_XOR_AGG Analytic Functions
- Blockchain Tables in Oracle Database 21c
- CHECKSUM Analytic Function
- JSON Support Enhancements in Oracle Database 21c
- JSON Data Type in Oracle 21c
- KURTOSIS_POP and KURTOSIS_SAMP Analytic Functions
- SKEWNESS_POP and SKEWNESS_SAMP Analytic Functions
- SQL Macros in Oracle Database 21c
- SQL Set Operator Enhancements (EXCEPT, EXCEPT ALL, MINUS ALL, INTERSECT ALL) in Oracle Database 21c
- Using Expressions in Initialization Parameters in Oracle Database 21c
PL/SQL Articles.
- 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 LOOP Iteration Enhancements in Oracle Database 21c
- JSON Support Enhancements in Oracle Database 21c
- JSON Data Type in Oracle 21c
- Qualified Expressions Enhancements in Oracle Database 21c
For more information see:
Hope this helps. Regards Tim...