Chris Saxon
@chrisrsaxon.bsky.social
Oracle Developer Advocate for SQL. Lover of quizzes and games of all kinds. Any views expressed belong to me.
chrissaxon.co.uk
chrissaxon.co.uk
Heading out on the Oracle ACE Adventure to Cadbury World
November 30, 2025 at 9:58 AM
Heading out on the Oracle ACE Adventure to Cadbury World
Reposted by Chris Saxon
Like #SQL?
Like puzzles?
Try #SQuizL
A free, daily guess-the-SQL statement quiz
You have up to six attempts to complete the statement on the top left using the fragments below
There's a new statement to guess at every day at midnight UTC
Play now at buff.ly/Myg8265
Like puzzles?
Try #SQuizL
A free, daily guess-the-SQL statement quiz
You have up to six attempts to complete the statement on the top left using the fragments below
There's a new statement to guess at every day at midnight UTC
Play now at buff.ly/Myg8265
November 28, 2025 at 12:00 PM
Like #SQL?
Like puzzles?
Try #SQuizL
A free, daily guess-the-SQL statement quiz
You have up to six attempts to complete the statement on the top left using the fragments below
There's a new statement to guess at every day at midnight UTC
Play now at buff.ly/Myg8265
Like puzzles?
Try #SQuizL
A free, daily guess-the-SQL statement quiz
You have up to six attempts to complete the statement on the top left using the fragments below
There's a new statement to guess at every day at midnight UTC
Play now at buff.ly/Myg8265
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
November 19, 2025 at 8:23 AM
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
freesql.com gives free access to an Oracle AI Database schema
You can connect to it from VS Code or any other client with SQL*Net
#DOAG2025
You can connect to it from VS Code or any other client with SQL*Net
#DOAG2025
November 18, 2025 at 10:38 AM
freesql.com gives free access to an Oracle AI Database schema
You can connect to it from VS Code or any other client with SQL*Net
#DOAG2025
You can connect to it from VS Code or any other client with SQL*Net
#DOAG2025
Reposted by Chris Saxon
How to Sell Data Modeling - good stuff from @joereis.bsky.social
practicaldatamodeling.substack.com/p/how-to-sel...
practicaldatamodeling.substack.com/p/how-to-sel...
How to Sell Data Modeling
Making the Invisible Visible
practicaldatamodeling.substack.com
November 17, 2025 at 4:27 PM
How to Sell Data Modeling - good stuff from @joereis.bsky.social
practicaldatamodeling.substack.com/p/how-to-sel...
practicaldatamodeling.substack.com/p/how-to-sel...
Reposted by Chris Saxon
I wrote about the GraphQL table function over a year ago, but in 26ai it is now in the documentation.
GraphQL in Oracle Database 23ai/26ai
oracle-base.com/articles/23/...
@OracleDatabase #database #26ai
GraphQL in Oracle Database 23ai/26ai
oracle-base.com/articles/23/...
@OracleDatabase #database #26ai
November 13, 2025 at 7:13 AM
I wrote about the GraphQL table function over a year ago, but in 26ai it is now in the documentation.
GraphQL in Oracle Database 23ai/26ai
oracle-base.com/articles/23/...
@OracleDatabase #database #26ai
GraphQL in Oracle Database 23ai/26ai
oracle-base.com/articles/23/...
@OracleDatabase #database #26ai
Reposted by Chris Saxon
QUALIFY Clause in Oracle AI Database 26ai
oracle-base.com/articles/26/...
@OracleDatabase #database #26ai
oracle-base.com/articles/26/...
@OracleDatabase #database #26ai
November 12, 2025 at 7:48 AM
QUALIFY Clause in Oracle AI Database 26ai
oracle-base.com/articles/26/...
@OracleDatabase #database #26ai
oracle-base.com/articles/26/...
@OracleDatabase #database #26ai
Reposted by Chris Saxon
🚨 Fresh off the press!
📣 A long overdue post on What's #New for #Developers in #Oracle #AI #Database 23.26.0
📣 A long overdue post on What's #New for #Developers in #Oracle #AI #Database 23.26.0
What’s new for Developers in Oracle AI Database 23.26.0
For more information on what’s new in Oracle Database 23.9, see: What’s new for Developers in Oracle Database 23.9 Oracle AI Database 23.26.0 brings some fantastic new features to developers—again! This release has quite a broad spectrum of new features, some of which are near and dear to everyday developers, such as the SQL QUALIFY clause, and some of them help venture into new(er) avenues, such as GraphQL support.
www.geraldonit.com
November 11, 2025 at 2:00 PM
🚨 Fresh off the press!
📣 A long overdue post on What's #New for #Developers in #Oracle #AI #Database 23.26.0
📣 A long overdue post on What's #New for #Developers in #Oracle #AI #Database 23.26.0
Reposted by Chris Saxon
📚 New Reading List is out!
This week, we have a lot of #technical #details for #Oracle #Database, #OCI and Oracle #Linux
Happy reading!
This week, we have a lot of #technical #details for #Oracle #Database, #OCI and Oracle #Linux
Happy reading!
Reading List – November 2025 #2
📰 xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates) - Tanel Poder explains the importance of row-count estimates and shares some useful scripts 📺 Installing Oracle Linux 10 - Oracle Learning demonstrates how to install Oracle Linux 10 📰 🤖 In-database AI inference on Oracle Active Data Guard: A practical walkthrough - Ludovico Caldara offloads AI inference workloads into Active Data Guard standby instances without the need for CQRS…
www.geraldonit.com
November 10, 2025 at 2:00 PM
Reposted by Chris Saxon
Small change, but so useful.
RESETTABLE Clause to in Oracle AI Database 26ai
oracle-base.com/articles/26/...
@OracleDatabase #database #26ai
RESETTABLE Clause to in Oracle AI Database 26ai
oracle-base.com/articles/26/...
@OracleDatabase #database #26ai
November 10, 2025 at 8:21 AM
Small change, but so useful.
RESETTABLE Clause to in Oracle AI Database 26ai
oracle-base.com/articles/26/...
@OracleDatabase #database #26ai
RESETTABLE Clause to in Oracle AI Database 26ai
oracle-base.com/articles/26/...
@OracleDatabase #database #26ai
Reposted by Chris Saxon
FreeSQL.com now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.
FreeSQL.com
November 6, 2025 at 10:42 PM
FreeSQL.com now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.
Reposted by Chris Saxon
Congrats to the Oracle Dev Gym Weekly DB winners for Oct 2025:
1st Stelios Vlasopoulos
2nd Mahamoutou
3rd Karel_Prech
🍾🏆👏
Well done to all who took part
Think you know more about Oracle #SQL?
Take the Weekly Database quiz at devgym.oracle.com/pls/apex/f?p...
1st Stelios Vlasopoulos
2nd Mahamoutou
3rd Karel_Prech
🍾🏆👏
Well done to all who took part
Think you know more about Oracle #SQL?
Take the Weekly Database quiz at devgym.oracle.com/pls/apex/f?p...
November 3, 2025 at 3:49 PM
Congrats to the Oracle Dev Gym Weekly DB winners for Oct 2025:
1st Stelios Vlasopoulos
2nd Mahamoutou
3rd Karel_Prech
🍾🏆👏
Well done to all who took part
Think you know more about Oracle #SQL?
Take the Weekly Database quiz at devgym.oracle.com/pls/apex/f?p...
1st Stelios Vlasopoulos
2nd Mahamoutou
3rd Karel_Prech
🍾🏆👏
Well done to all who took part
Think you know more about Oracle #SQL?
Take the Weekly Database quiz at devgym.oracle.com/pls/apex/f?p...
Reposted by Chris Saxon
Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post:
danischnider.wordpress.com/2025/10/24/q...
danischnider.wordpress.com/2025/10/24/q...
QUALIFY: The WHERE Condition for Analytic Functions
Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…
danischnider.wordpress.com
October 24, 2025 at 2:35 PM
Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post:
danischnider.wordpress.com/2025/10/24/q...
danischnider.wordpress.com/2025/10/24/q...
Yesterday's #SQuizL was tricky for many, the solution was
SELECT emperor FROM japan AS OF PERIOD FOR meiji_era DATE '1868-10-23'
This uses the temporal period meiji_era to find rows active on the date passed
Today's seems challenging too - can you guess it?
devgym.oracle.com/pls/apex/f?p...
SELECT emperor FROM japan AS OF PERIOD FOR meiji_era DATE '1868-10-23'
This uses the temporal period meiji_era to find rows active on the date passed
Today's seems challenging too - can you guess it?
devgym.oracle.com/pls/apex/f?p...
October 24, 2025 at 12:36 PM
Yesterday's #SQuizL was tricky for many, the solution was
SELECT emperor FROM japan AS OF PERIOD FOR meiji_era DATE '1868-10-23'
This uses the temporal period meiji_era to find rows active on the date passed
Today's seems challenging too - can you guess it?
devgym.oracle.com/pls/apex/f?p...
SELECT emperor FROM japan AS OF PERIOD FOR meiji_era DATE '1868-10-23'
This uses the temporal period meiji_era to find rows active on the date passed
Today's seems challenging too - can you guess it?
devgym.oracle.com/pls/apex/f?p...
Reposted by Chris Saxon
One cool thing we have since this year’s AI World - #Dev Tips cards for #OracleDatabase
Shout out to @richard.fichtner.dev for the great idea!
Shout out to @richard.fichtner.dev for the great idea!
October 22, 2025 at 3:53 PM
One cool thing we have since this year’s AI World - #Dev Tips cards for #OracleDatabase
Shout out to @richard.fichtner.dev for the great idea!
Shout out to @richard.fichtner.dev for the great idea!
Reposted by Chris Saxon
📚 New Reading List is out!
🤖 🗺️ 📣 Including #OracleAIWorld coverage!
🎉 🎉 🎉 Lots and lots of amazing #announcements from last week
🤓 Blog posts for #geeks, and more
📖 Don't wait, READ NOW!
🤖 🗺️ 📣 Including #OracleAIWorld coverage!
🎉 🎉 🎉 Lots and lots of amazing #announcements from last week
🤓 Blog posts for #geeks, and more
📖 Don't wait, READ NOW!
Reading List – October 2025 #3
🏆 🤖 Oracle Breaks New Ground in Multilingual Text-to-SQL by Winning Archer Challenge - Oracle’s Reasoning-based Natural Language to SQL Solution – a Generative AI–based Agentic solution, has won the first place in the 2025 Archer NL2SQL Evaluation Challenge 🎉 🤖 Oracle Unveils New Defense Ecosystem Members - Oracle announces the second cohort of the Oracle Defense Ecosystem, established in June 2025, to brings together leading startups, scale-ups, and established enterprises to drive AI and cyber innovation and enhance national security…
www.geraldonit.com
October 21, 2025 at 1:00 PM
📚 New Reading List is out!
🤖 🗺️ 📣 Including #OracleAIWorld coverage!
🎉 🎉 🎉 Lots and lots of amazing #announcements from last week
🤓 Blog posts for #geeks, and more
📖 Don't wait, READ NOW!
🤖 🗺️ 📣 Including #OracleAIWorld coverage!
🎉 🎉 🎉 Lots and lots of amazing #announcements from last week
🤓 Blog posts for #geeks, and more
📖 Don't wait, READ NOW!
The #SQL analysis report in Oracle AI Database 26ai shows potential problems in a query
Cartesian products
UNION
Non sargable filters (can’t use indexes)
You can use this to find queries in the cursor cache which you may be able to improve
Cartesian products
UNION
Non sargable filters (can’t use indexes)
You can use this to find queries in the cursor cache which you may be able to improve
October 16, 2025 at 5:31 PM
The #SQL analysis report in Oracle AI Database 26ai shows potential problems in a query
Cartesian products
UNION
Non sargable filters (can’t use indexes)
You can use this to find queries in the cursor cache which you may be able to improve
Cartesian products
UNION
Non sargable filters (can’t use indexes)
You can use this to find queries in the cursor cache which you may be able to improve
Run natural language queries against Oracle AI Database with
SELECT AI
e.g.
SELECT AI what are the top 10 movies
Michelle Malcher demos and gives example use cases for it #AIWorld
SELECT AI
e.g.
SELECT AI what are the top 10 movies
Michelle Malcher demos and gives example use cases for it #AIWorld
October 16, 2025 at 4:21 PM
Run natural language queries against Oracle AI Database with
SELECT AI
e.g.
SELECT AI what are the top 10 movies
Michelle Malcher demos and gives example use cases for it #AIWorld
SELECT AI
e.g.
SELECT AI what are the top 10 movies
Michelle Malcher demos and gives example use cases for it #AIWorld
Reposted by Chris Saxon
Oracle AI Database 26ai replaces Oracle Database 23ai
Read more here:
mikedietrichde.com/2025/10/14/o...
Read more here:
mikedietrichde.com/2025/10/14/o...
Oracle AI Database 26ai replaces Oracle Database 23ai
Larry Ellison announced Oracle AI Database 26ai today in his keynote at Oracle AI World conference in Las Vegas. And I am pretty certain you may want some clarification on what this means exactly.…
mikedietrichde.com
October 15, 2025 at 1:24 PM
Oracle AI Database 26ai replaces Oracle Database 23ai
Read more here:
mikedietrichde.com/2025/10/14/o...
Read more here:
mikedietrichde.com/2025/10/14/o...
Reposted by Chris Saxon
Oracle 26ai¹ was released yesterday.
From the SQL standpoint it's worth mentioning that is has got the QUALIFY clause:
I bet this starts an avalanche (there are already PostgreSQL patches).
modern-sql.com/caniuse/qual...
¹ 26ai is the marketing version, 23.26.0 is the technical version.
From the SQL standpoint it's worth mentioning that is has got the QUALIFY clause:
I bet this starts an avalanche (there are already PostgreSQL patches).
modern-sql.com/caniuse/qual...
¹ 26ai is the marketing version, 23.26.0 is the technical version.
QUALIFY clause (window functions)
QUALIFY: filter rows based on window functions
modern-sql.com
October 15, 2025 at 3:36 PM
Oracle 26ai¹ was released yesterday.
From the SQL standpoint it's worth mentioning that is has got the QUALIFY clause:
I bet this starts an avalanche (there are already PostgreSQL patches).
modern-sql.com/caniuse/qual...
¹ 26ai is the marketing version, 23.26.0 is the technical version.
From the SQL standpoint it's worth mentioning that is has got the QUALIFY clause:
I bet this starts an avalanche (there are already PostgreSQL patches).
modern-sql.com/caniuse/qual...
¹ 26ai is the marketing version, 23.26.0 is the technical version.