DBA Hub

📋Steps in this guide1/2

Oracle SQL and PL/SQL Enhancements in Oracle Database 23ai/26ai

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

oracle 23configurationintermediate
by OracleDba
14 views
1

Overview

This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 23ai/26ai. SQL Articles. - Aggregation over INTERVAL Datatypes in Oracle Database 23ai/26ai - Annotations in Oracle Database 23ai/26ai - Automatic PL/SQL to SQL Transpiler in Oracle Database 23ai/26ai - Auditing Enhancements in Oracle Database 23ai/26ai - Blockchain Table Enhancements in Oracle Database 23ai/26ai - Boolean Data Type in Oracle Database 23ai/26ai - CASE Statement and CASE Expression Enhancements in Oracle Database 23ai/26ai - CEIL and FLOOR Support DATE, TIMESTAMP, and INTERVAL Data Types in Oracle Database 23ai/26ai - DB_DEVELOPER_ROLE Role in Oracle Database 23ai/26ai - DEFAULT ON NULL FOR INSERT AND UPDATE in Oracle Database 23ai/26ai - Direct Joins for UPDATE and DELETE Statements in Oracle Database 23ai/26ai - DML RETURNING Clause Enhancements in Oracle Database 23ai/26ai - Domains in Oracle Database 23ai/26ai - FUZZY_MATCH and PHONIC_ENCODE Data Quality Operators in Oracle Database 23ai/26ai - GraphQL in Oracle Database 23ai/26ai - GROUP BY ALL in Oracle Database 23ai/26ai - GROUP BY and HAVING Clauses Using Column Aliases in Oracle Database 23ai/26ai - Hybrid Partitioned Table Enhancements in Oracle Database 23ai/26ai - IF [NOT] EXISTS DDL Clause in Oracle Database 23ai/26ai - Immutable Table Enhancements in Oracle Database 23ai/26ai - JSON_ARRAY Using Subqueries in Oracle Database 23ai - JSON Data Type Constructor Enhancements in Oracle Database 23ai/26ai - JSON-Relational Duality Views in Oracle Database 23ai/26ai - JSON Schema in Oracle 23ai/26ai - JSON_SERIALIZE : ORDERED Keyword in Oracle Database 23ai/26ai - JSON Support Enhancements in Oracle Database 23ai/26ai - JSON_TRANSFORM Enhancements in Oracle Database 23ai/26ai - JSON Type Modifier Enhancements in Oracle Database 23ai/26ai - JSON_VALUE Function Enhancements in Oracle Database 23ai/26ai - Lock-Free Reservations to Prevent Blocking Sessions in Oracle Database 23ai/26ai - Materialized View Enhancements in Oracle Database 23ai/26ai - MAX_COLUMNS : Increase the Maximum Number of Columns for a Table in Oracle Database 23ai/26ai - Migrating Text-Based JSON to JSON Data Type : Pre-Migration Check in Oracle Database 23ai/26ai - Non-Positional INSERT INTO SET and INSERT INTO BY NAME Clauses in Oracle Database 23ai/26ai - Precheck JSON Constraints in Oracle Database 23ai/26ai - Predicates for JSON_QUERY and JSON_VALUE in Oracle Database 23ai/26ai - QUALIFY Clause in Oracle AI Database 26ai - Read-Only PDB Users in Oracle Database 23ai/26ai - Removal of Touch-Once Restriction after Parallel DML (Unrestricted Direct Loads) in Oracle Database 23ai/26ai - Rename LOB Segments in Oracle Database 23ai/26ai - Schema Privileges in Oracle Database 23ai/26ai - SELECT Without FROM Clause in Oracle Database 23ai/26ai - SQL Property Graphs and SQL/PGQ in Oracle Database 23ai/26ai - Staging Tables in Oracle Database 23ai/26ai - Table Values Constructor in Oracle Database 23ai/26ai - UUID() Function in Oracle Database 23ai/26ai - XML, JSON and Oracle Text Search Index Enhancements in Oracle Database 23ai/26ai - 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/26ai - CASE Statement and CASE Expression Enhancements in Oracle Database 23ai/26ai - DML RETURNING Clause Enhancements in Oracle Database 23ai/26ai - JSON Data Type Constructor Enhancements in Oracle Database 23ai/26ai - JSON_VALUE Function Enhancements in Oracle Database 23ai - Migrating Text-Based JSON to JSON Data Type : Pre-Migration Check in Oracle Database 23ai/26ai - RESETTABLE Clause in Oracle AI Database 26ai - Transport Layer Security (TLS) Connections without a Client Wallet in Oracle Database 23ai/26ai For more information see:
2

Section 2

- Oracle SQL 23ai/26ai Articles - Oracle PL/SQL 23ai/26ai Articles Hope this helps. Regards Tim...

Comments (0)

Please to add comments

No comments yet. Be the first to comment!