Oracle SQL and PL/SQL Enhancements in Oracle Database 23c

This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 23c.

SQL Articles.

Aggregation over INTERVAL Datatypes in Oracle Database 23c
Annotations in Oracle Database 23c
Automatic PL/SQL to SQL Transpiler in Oracle Database 23c
Boolean Data Type in Oracle Database 23c
CASE Statement and CASE Expression Enhancements in Oracle Database 23c
CEIL and FLOOR Support DATE, TIMESTAMP, and INTERVAL Data Types in Oracle Database 23c
DB_DEVELOPER_ROLE Role in Oracle Database 23c
DEFAULT ON NULL FOR INSERT AND UPDATE in Oracle Database 23c
Direct Joins for UPDATE and DELETE Statements in Oracle Database 23c
DML RETURNING Clause Enhancements in Oracle Database 23c
Domains in Oracle Database 23c
FUZZY_MATCH and PHONIC_ENCODE Data Quality Operators in Oracle Database 23c
GROUP BY and HAVING Clauses Using Column Aliases in Oracle Database 23c
IF [NOT] EXISTS DDL Clause in Oracle Database 23c
JSON_ARRAY Using Subqueries in Oracle Database 23c
JSON Data Type Constructor Enhancements in Oracle Database 23c
JSON-Relational Duality Views in Oracle Database 23c
JSON Schema in Oracle 23c
JSON_SERIALIZE : ORDERED Keyword in Oracle Database 23c
JSON Support Enhancements in Oracle Database 23c
JSON_TRANSFORM Enhancements in Oracle Database 23c
JSON_VALUE Function Enhancements in Oracle Database 23c
Lock-Free Reservations to Prevent Blocking Sessions in Oracle Database 23c
MAX_COLUMNS : Increase the Maximum Number of Columns for a Table in Oracle Database 23c
Migrating Text-Based JSON to JSON Data Type : Pre-Migration Check in Oracle Database 23c
Precheck JSON Constraints in Oracle Database 23c
Predicates for JSON_QUERY and JSON_VALUE in Oracle Database 23
Removal of Touch-Once Restriction after Parallel DML (Unrestricted Direct Loads) in Oracle Database 23c
Schema Privileges in Oracle Database 23c
SELECT Without FROM Clause in Oracle Database 23c
SQL Property Graphs and SQL/PGQ in Oracle Database 23c
Table Values Constructor in Oracle Database 23c
XML, JSON and Oracle Text Search Index Enhancements in Oracle Database 23c
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 23c
CASE Statement and CASE Expression Enhancements in Oracle Database 23c
DML RETURNING Clause Enhancements in Oracle Database 23c
JSON Data Type Constructor Enhancements in Oracle Database 23c
JSON_VALUE Function Enhancements in Oracle Database 23c
Migrating Text-Based JSON to JSON Data Type : Pre-Migration Check in Oracle Database 23c

For more information see:

Oracle SQL 23c Articles
Oracle PL/SQL 23c Articles

Hope this helps. Regards Tim...

Back to the Top.