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
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.
October 14, 2025 at 4:50 PM
Reposted by Chris Saxon
speed sql - I love it!
Speed SQL results for quiz on 07-OCT-2025
Attempt #1: 10 correct in 43 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 07-OCT-2025
Attempt #1: 10 correct in 43 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
October 7, 2025 at 6:28 AM
speed sql - I love it!
Speed SQL results for quiz on 07-OCT-2025
Attempt #1: 10 correct in 43 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 07-OCT-2025
Attempt #1: 10 correct in 43 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Lots struggled with yesterday's #SQuizL!
Recognizing the first transaction on the Helsinki stock exchange, the solution was
SET TRANSACTION READ WRITE NAME q'[Helsinki Stock Exchange]'
This names the db transaction
Can you guess today's statement from the clue?
devgym.oracle.com/pls/apex/f?p...
Recognizing the first transaction on the Helsinki stock exchange, the solution was
SET TRANSACTION READ WRITE NAME q'[Helsinki Stock Exchange]'
This names the db transaction
Can you guess today's statement from the clue?
devgym.oracle.com/pls/apex/f?p...
October 8, 2025 at 9:34 AM
Lots struggled with yesterday's #SQuizL!
Recognizing the first transaction on the Helsinki stock exchange, the solution was
SET TRANSACTION READ WRITE NAME q'[Helsinki Stock Exchange]'
This names the db transaction
Can you guess today's statement from the clue?
devgym.oracle.com/pls/apex/f?p...
Recognizing the first transaction on the Helsinki stock exchange, the solution was
SET TRANSACTION READ WRITE NAME q'[Helsinki Stock Exchange]'
This names the db transaction
Can you guess today's statement from the clue?
devgym.oracle.com/pls/apex/f?p...
In this month's SQL Ask TOM Live session, Ric Van Dyke is joining me to discuss how to
Use the WITH clause
Optimize #SQL queries using WITH
Join us at Tues 21ct Oct, 2pm UK time asktom.oracle.com/ords/r/tech/...
Use the WITH clause
Optimize #SQL queries using WITH
Join us at Tues 21ct Oct, 2pm UK time asktom.oracle.com/ords/r/tech/...
October 7, 2025 at 2:29 PM
In this month's SQL Ask TOM Live session, Ric Van Dyke is joining me to discuss how to
Use the WITH clause
Optimize #SQL queries using WITH
Join us at Tues 21ct Oct, 2pm UK time asktom.oracle.com/ords/r/tech/...
Use the WITH clause
Optimize #SQL queries using WITH
Join us at Tues 21ct Oct, 2pm UK time asktom.oracle.com/ords/r/tech/...
Congrats to the Oracle Dev Gym Weekly DB winners for Sept 2025:
1st Stelios Vlasopoulos
2nd Andrey Zaytsev
3rd mentzel.iudith
🍾🏆👏
This dedicated trio are also the top-3 ranked players for Q3 2025
See the full rankings at devgym.oracle.com/pls/apex/f?p...
1st Stelios Vlasopoulos
2nd Andrey Zaytsev
3rd mentzel.iudith
🍾🏆👏
This dedicated trio are also the top-3 ranked players for Q3 2025
See the full rankings at devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
October 6, 2025 at 3:33 PM
Congrats to the Oracle Dev Gym Weekly DB winners for Sept 2025:
1st Stelios Vlasopoulos
2nd Andrey Zaytsev
3rd mentzel.iudith
🍾🏆👏
This dedicated trio are also the top-3 ranked players for Q3 2025
See the full rankings at devgym.oracle.com/pls/apex/f?p...
1st Stelios Vlasopoulos
2nd Andrey Zaytsev
3rd mentzel.iudith
🍾🏆👏
This dedicated trio are also the top-3 ranked players for Q3 2025
See the full rankings at devgym.oracle.com/pls/apex/f?p...
Reposted by Chris Saxon
📚 New Reading List is out!
🤓 This week, we got a lot of geeky blog posts to read through!
Happy reading!
🤓 This week, we got a lot of geeky blog posts to read through!
Happy reading!
Reading List – October 2025 #1
📰 rowlen surprise - Jonathan Lewis explains the avg_row_len and num_rows columns in user_tables 📰 Oracle DB 23ai supports external Apache Iceberg tables - Bryan Grenn shows how you can query Apache Iceberg files with Oracle Database 23ai 🏆 Governor Hochul Announces $218 Million Investment to Improve Patient Care - The NY State Office of Mental Health awards Oracle Health the funding to create a comprehensive statewide electronic health record system…
www.geraldonit.com
October 6, 2025 at 1:01 PM
📚 New Reading List is out!
🤓 This week, we got a lot of geeky blog posts to read through!
Happy reading!
🤓 This week, we got a lot of geeky blog posts to read through!
Happy reading!
#SQL is second in the IEEE Top Programming Languages for jobs in 2025
Good going for a language that's over 50 years old!
spectrum.ieee.org/top-programm...
Good going for a language that's over 50 years old!
spectrum.ieee.org/top-programm...
September 24, 2025 at 2:42 PM
#SQL is second in the IEEE Top Programming Languages for jobs in 2025
Good going for a language that's over 50 years old!
spectrum.ieee.org/top-programm...
Good going for a language that's over 50 years old!
spectrum.ieee.org/top-programm...
Reposted by Chris Saxon
Join the Oracle Dev Gym (FREE!) and build your Oracle technology muscles by taking workouts, quizzes, and even entire classes on SQL, PL/SQL, database design, logic and more. 💪 social.ora.cl/6019AE8VJ
social.ora.cl
September 18, 2025 at 8:05 PM
Join the Oracle Dev Gym (FREE!) and build your Oracle technology muscles by taking workouts, quizzes, and even entire classes on SQL, PL/SQL, database design, logic and more. 💪 social.ora.cl/6019AE8VJ
Oracle Database 23ai added direct join syntax for updates
UPDATE t1
SET t1.col = t2.col
FROM t2
WHERE
My latest post looks at this and other methods for updating one table from another
Update only merge
Updating a query
Correlated subquery update
blogs.oracle.com/sql/post/how...
UPDATE t1
SET t1.col = t2.col
FROM t2
WHERE
My latest post looks at this and other methods for updating one table from another
Update only merge
Updating a query
Correlated subquery update
blogs.oracle.com/sql/post/how...
September 16, 2025 at 10:03 AM
Oracle Database 23ai added direct join syntax for updates
UPDATE t1
SET t1.col = t2.col
FROM t2
WHERE
My latest post looks at this and other methods for updating one table from another
Update only merge
Updating a query
Correlated subquery update
blogs.oracle.com/sql/post/how...
UPDATE t1
SET t1.col = t2.col
FROM t2
WHERE
My latest post looks at this and other methods for updating one table from another
Update only merge
Updating a query
Correlated subquery update
blogs.oracle.com/sql/post/how...
Happy Birthday #SQuizL!
The daily Wordle-style guess the SQL statement quiz turns 2 today
We hope it makes for a fun way to learn Oracle #SQL syntax
Big thanks to Eli Feuerstein for building it
Play today at devgym.oracle.com/pls/apex/f?p...
The daily Wordle-style guess the SQL statement quiz turns 2 today
We hope it makes for a fun way to learn Oracle #SQL syntax
Big thanks to Eli Feuerstein for building it
Play today at devgym.oracle.com/pls/apex/f?p...
September 11, 2025 at 12:26 PM
Happy Birthday #SQuizL!
The daily Wordle-style guess the SQL statement quiz turns 2 today
We hope it makes for a fun way to learn Oracle #SQL syntax
Big thanks to Eli Feuerstein for building it
Play today at devgym.oracle.com/pls/apex/f?p...
The daily Wordle-style guess the SQL statement quiz turns 2 today
We hope it makes for a fun way to learn Oracle #SQL syntax
Big thanks to Eli Feuerstein for building it
Play today at devgym.oracle.com/pls/apex/f?p...