23c/26ai New Features

As of January 2026, Oracle AI Database 26 AI is The latest release of the world’s first commercially available RDBMS.  23/26AI brings to users a ton of features including : AI enhancements, JSON features, Vector searching, Graph queries, True Cache and many more performance and Security features. Here I will share some of my favorite ones and how they could help solve problems in the real world.

book, calendar, paper, calendar, calendar, calendar, calendar, calendar

Calendar Functions and Date Dims in Oracle Database 26ai

Leave a Comment / 23c/26ai New Features, SQL AND PL/SQL / /

Introduction Calendar functions, introduced in 23.26.1, provide us with the ability to format dates into standard year/quarter/month/week/day text for these calendars: Each formatted calendar function returns a VARCHAR2 value representing the input date at a particular level of the calendar hierarchy. In this post, I will discuss the Calendar type functions and how to use

Calendar Functions and Date Dims in Oracle Database 26ai Read More »

Monochrome image of three vintage alarm clocks highlighting the passage of time.

DML WAIT[NOWAIT] in Oracle AI Database 26ai

Leave a Comment / 23c/26ai New Features, Daily DBA Stuff / /

Introduction DML WAIT[NOWAIT], introduced in 23.26.2.0.0, helps to specify how long a DML statement should wait to acquire a lock before rolling back the DML statement and returning session control to the user. The general syntax is: You can specify whether to wait forever, not at all or for n seconds, milliseconds or microseconds. The

DML WAIT[NOWAIT] in Oracle AI Database 26ai Read More »

Nested with clauses oracle 26ai

Nesting With Clauses in Oracle database 26ai

Leave a Comment / 23c/26ai New Features, SQL AND PL/SQL / /

BACKGROUND Consider this post from stackoverflow. As seen above, Nesting of with clauses is not possible in oracle and while the examples in the answer are simple and straightforward allowing you to define multiple different subqueries, sometimes (and I know because I’ve been there) you actually need to or at least wish you would nest

Nesting With Clauses in Oracle database 26ai Read More »

Conditional Filter For Aggregates In Oracle Database 26ai

Leave a Comment / 23c/26ai New Features, SQL AND PL/SQL / /

BACKGROUND Consider this problem from LeetCode: leetcode_db_1158, about figuring out for each user, the number of orders they made in 2019. The code below can create the sample data set needed for the question. Here’s an Oracle SQL solution to this problem Notice the left join to a subquery highlighted above! This is done to

Conditional Filter For Aggregates In Oracle Database 26ai Read More »

Non-Positional Inserts in Oracle AI Database 26ai

Leave a Comment / 23c/26ai New Features, SQL AND PL/SQL / /

Background Oracle AI Database 26ai provides new, easier and self documenting syntax for insert statements: Non-positional Inserts. This makes use of the INSERT INTO SET  and BY NAME clauses The SET clause works similarly to the existing set clause for update statements, and the by name clause makes it easier to insert the results of

Non-Positional Inserts in Oracle AI Database 26ai Read More »