8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Oracle SQL and PL/SQL Enhancements in Oracle Database 23ai
This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 23ai.
SQL Articles.
- Aggregation over INTERVAL Datatypes in Oracle Database 23ai
- Annotations in Oracle Database 23ai
- Automatic PL/SQL to SQL Transpiler in Oracle Database 23ai
- Auditing Enhancements in Oracle Database 23ai
- Blockchain Table Enhancements in Oracle Database 23ai
- Boolean Data Type in Oracle Database 23ai
- CASE Statement and CASE Expression Enhancements in Oracle Database 23ai
- CEIL and FLOOR Support DATE, TIMESTAMP, and INTERVAL Data Types in Oracle Database 23
- DB_DEVELOPER_ROLE Role in Oracle Database 23ai
- DEFAULT ON NULL FOR INSERT AND UPDATE in Oracle Database 23ai
- Direct Joins for UPDATE and DELETE Statements in Oracle Database 23ai
- DML RETURNING Clause Enhancements in Oracle Database 23ai
- Domains in Oracle Database 23ai
- FUZZY_MATCH and PHONIC_ENCODE Data Quality Operators in Oracle Database 23ai
- GROUP BY and HAVING Clauses Using Column Aliases in Oracle Database 23ai
- Hybrid Partitioned Table Enhancements in Oracle Database 23ai
- IF [NOT] EXISTS DDL Clause in Oracle Database 23ai
- Immutable Table Enhancements in Oracle Database 23ai
- JSON_ARRAY Using Subqueries in Oracle Database 23ai
- JSON Data Type Constructor Enhancements in Oracle Database 23ai
- JSON-Relational Duality Views in Oracle Database 23ai
- JSON Schema in Oracle 23ai
- JSON_SERIALIZE : ORDERED Keyword in Oracle Database 23ai
- JSON Support Enhancements in Oracle Database 23ai
- JSON_TRANSFORM Enhancements in Oracle Database 23ai
- JSON_VALUE Function Enhancements in Oracle Database 23ai
- Lock-Free Reservations to Prevent Blocking Sessions in Oracle Database 23ai
- Materialized View Enhancements in Oracle Database 23ai
- MAX_COLUMNS : Increase the Maximum Number of Columns for a Table in Oracle Database 23ai
- Migrating Text-Based JSON to JSON Data Type : Pre-Migration Check in Oracle Database 23ai
- Precheck JSON Constraints in Oracle Database 23ai
- Predicates for JSON_QUERY and JSON_VALUE in Oracle Database 23
- Read-Only PDB Users in Oracle Database 23ai
- Removal of Touch-Once Restriction after Parallel DML (Unrestricted Direct Loads) in Oracle Database 23ai
- Rename LOB Segments in Oracle Database 23ai
- Schema Privileges in Oracle Database 23ai
- SELECT Without FROM Clause in Oracle Database 23ai
- SQL Property Graphs and SQL/PGQ in Oracle Database 23ai
- Staging Tables in Oracle Database 23ai
- Table Values Constructor in Oracle Database 23ai
- XML, JSON and Oracle Text Search Index Enhancements in Oracle Database 23ai
- The National Language Support (NLS) data files for AL32UTF8 and AL16UTF16 character sets are updated to match version 15.0 of the Unicode Standard character database.
PL/SQL Articles.
- Automatic PL/SQL to SQL Transpiler in Oracle Database 23ai
- CASE Statement and CASE Expression Enhancements in Oracle Database 23ai
- DML RETURNING Clause Enhancements in Oracle Database 23ai
- JSON Data Type Constructor Enhancements in Oracle Database 23ai
- JSON_VALUE Function Enhancements in Oracle Database 23ai
- Migrating Text-Based JSON to JSON Data Type : Pre-Migration Check in Oracle Database 23ai
- Transport Layer Security (TLS) Connections without a Client Wallet in Oracle Database 23ai
For more information see:
Hope this helps. Regards Tim...