Chris Saxon
chrisrsaxon.bsky.social
Chris Saxon
@chrisrsaxon.bsky.social
680 followers 34 following 210 posts
Oracle Developer Advocate for SQL. Lover of quizzes and games of all kinds. Any views expressed belong to me. chrissaxon.co.uk
Posts Media Videos Starter Packs
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
Reposted by Chris Saxon
FreeSQL.com now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.
FreeSQL.com
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...
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...
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!
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
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
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.
QUALIFY clause (window functions)
QUALIFY: filter rows based on window functions
modern-sql.com
Get your desks of #SQL tips at #AIWorld from the swag-as-a-service or Oracle AI Database booths
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...
devgym.oracle.com
That's FAST!

Great work :)
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...
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/...
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...
devgym.oracle.com
#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...
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
This also covers various issues you may hit

ORA-30926 => updating the same row twice
ORA-38104 => updating join columns in merge
ORA-01779 => changing non-key preserved tables in 19c and earlier
ORA-00934 => using aggregate functions
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...