8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | 24ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Oracle SQL and PL/SQL Enhancements in Oracle Database 18c
This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 18c.
SQL Articles.
- Approximate Top-N Query Processing (APPROX_RANK, APPROX_SUM, APPROX_COUNT)
- ALTER SYSTEM CANCEL SQL : Cancel a SQL Statement in a Session
- Inline External Tables
- JSON Data Guide Enhancements
- JSON_EQUAL Condition
- JSON_TABLE Enhancements
- Online MERGE PARTITION and MERGE SUBPARTITIONc
- Private Temporary Tables
- Scalable Sequences
- TREAT(... AS JSON)
- TO_UTC_TIMESTAMP_TZ Function
PL/SQL Articles.
- DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP in Oracle Database 18c
- Private Temporary Tables in Oracle Database 18c
- Polymorphic Table Functions in Oracle Database 18c
- Qualified Expressions (Populating Record Types and Associative Arrays) in PL/SQL in Oracle Database 18c
- Simple Oracle Document Access (SODA) for PL/SQL in Oracle Database 18c
For more information see:
Hope this helps. Regards Tim...