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.
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 […]
With the release of Oracle Database 23.26.2.0.0, A new join syntax JOIN TO ONE has been introduced. It’s meant to simplify the FROM clause and prevent duplicates that may arise from join conditions. This post explores this new feature and explains how it can be of help when writing SQL queries.
A bit of Background I have been reading a lot about autoupgrade. I see lots of oracle technologists talking about it on their blogs and videos and they recommend it. Having got tired of watching from the sidelines, wondering what all the fuzz is about and also due to my own enormous FOMO, I decided
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
In this post, I explain with examples the new oracle database 26ai feature “Group by Alias and group by All” I also discuss using the Having clause and Rollup as well as what to watch out for.
Group by Alias and Group by All in Oracle Database 26ai Read More »
A quick guide to Oracle 26ai’s extended VALUES constructor, showing how to insert, update, and merge multiple rows with cleaner, simpler SQL.
Table Values Constructor In Oracle Database 26ai Read More »
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 »
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 »
The Qualify clause in Oracle database 26ai makes it easier to filter on the results of window functions. See an example in this blog post.
Easier filtering of window functions with the Qualify clause in oracle AI Database 26ai Read More »
A Brief Primer: Database Constraints Database constraints enable developers to enforce business rules and data integrity right where the data lives, the tables! They help do things like ensure data uniqueness in a table, prevent incorrect data from being keyed in, prevent null values and enforce relationships between tables to name a few (I go
