Over the past year, Oracle AI Database has added a steady stream of new SQL features. To celebrate Joel Kallman Day, I wanted to highlight fantastic work from the Oracle community writing about these enhancements.

Here’s a recap of the features added and posts I’ve found by customers, partners, ACEs, and enthusiasts showing you how these work.

23.26.0

GraphQL table function

• Tim Hall: GraphQL in Oracle Database 23ai/26ai

QUALIFY clause

• Andrej Pashchenko: Oracle 26ai: QUALIFY Under the Hood
• Dani Schnider: QUALIFY: The WHERE Condition for Analytic Functions
• Harris Fungwi: Easier filtering of window functions with the Qualify clause in Oracle AI Database 26ai
• Quanwen Zhao: Qualify clause
• Tim Hall: QUALIFY Clause in Oracle AI Database 26ai

RESETTABLE clause

• Satishbabu Gunukula: Avoiding ORA-04068 Using RESETTABLE Packages in Oracle 26ai
• Tim Hall: RESETTABLE Clause in Oracle AI Database 26ai
• Vahid Yousefzadeh: Oracle AI Database 26ai: RESETTABLE Clause

23.26.1

Aggregation filters

• Dani Schnider: Aggregation Filters in Oracle 26ai
• Ian Carpenter: Oracle 26ai: Aggregation Filters
• Harris Fungwi: Conditional Filter For Aggregates In Oracle Database 26ai
• Hemant K Chitale: The new FILTER clause in Aggregations
• Oren Nakdimon: Aggregation Filters
• Tim Hall: Aggregation Filters in Oracle AI Database 26ai

Calendar functions

• Andrej Pashchenko: CALENDAR Functions in Oracle 26ai – Part 1
• Andrej Pashchenko: CALENDAR Functions in Oracle 26ai – Part 2
• Dani Schnider: Playing around with Calendar Functions in Oracle 26ai
• Harris Fungwi: Calendar Functions and Date Dims in Oracle Database 26ai
• Tim Hall: Calendar Functions in Oracle AI Database 26ai

DATEDIFF

• Vinish Kapoor: Oracle DATEDIFF Function: Syntax and Examples

Partition by expression

• Dani Schnider: Partition by Expression
• Hemant K Chitale: Partition by Expression

Assertions

• André van der Put: Assertions versus constraints
• André van der Put: Using Assertions to enforce Business Rules
• Anthony Harper: Group Composition Assertions I: Literal Rules
• Anthony Harper: Temporal SQL Assertions I: Unconditional and Unvalidated
• Anthony Harper: Temporal SQL Assertions II: Ignore Legacy Data
• Anthony Harper: Temporal SQL Assertions III: Effective Periods
• Dimitri Gielis: Oracle Database 26ai Assertions in a World Cup Betting App
• Franck Pachot: The Doctor’s On-Call Shift solved with SQL Assertions
• Franck Pachot: SQL Assertions, ANSI join, and ORA-08697
• Harris Fungwi: Assertions in Oracle AI Database 26ai
• Javier Morales Carreras: SQL Assertions
• Kim Berg Hansen: Assertions for data integrity on a less-than-ideal data model
• Philipp Salvisberg: Enforcing Acyclic Hierarchies With SQL Assertions
• Philipp Salvisberg: Using SQL Assertions to Enforce Temporal Data Integrity
• Piet de Visser: Assertions used in arc-relationship
• Piet de Visser: Oracle 26ai with Assertions – a quick look under the cover…
• Prashant Dixit: Oracle 26ai Assertions – The Database constraint that took years to ship
• Sean D. Stuber: Assertions in 26ai
• Tim Hall: Assertions in Oracle AI Database 26ai

23.26.2

Deep Data Security

• Jim Czuprynski: How to implement Deep Data Security (DeepSec) in Oracle 26ai: complete step-by-step guide (part one)
• Ronald Vargas: Oracle nueva característica en 23.26.3 Oracle AI Database 26ai: Qué es Deep Sec.?
• Vahid Yousefzadeh: Oracle Deep Data Security in Oracle AI Database 26ai: End Users and Data Roles

JOIN TO ONE

• Andrej Pashchenko: Oracle 26ai: A Closer Look at JOIN TO ONE
• Andrej Pashchenko: Oracle 26ai: An Even Closer Look at JOIN TO ONE
• Dani Schnider: JOIN TO ONE and Constraints
• Dani Schnider: JOIN TO ONE and Star Schemas
• Harris Fungwi: Join to one in Oracle Database 26ai
• Hemant K Chitale: New JOIN TO ONE clause in 26.2 SELECT

Nested WITH clauses

• Harris Fungwi: Nesting With Clauses in Oracle database 26ai
• Vahid Yousefzadeh: Nested WITH Clause in Oracle AI Database 26ai (23.26.2)

WAIT and NOWAIT for DML

• Harris Fungwi: DML WAIT[NOWAIT] in Oracle AI Database 26ai
• Hemant K Chitale: WAIT Clause for DMLs in 26.2

23.26.3

DATEADD

• Vinish Kapoor: Oracle DATEADD Function

We’ve got many more features planned for the future releases. I’m looking forward to see what the community writes about these!