Chris Saxon
chrisrsaxon.bsky.social
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
Add key-value metadata to

Tables
Views
Columns

in Oracle AI Database with annotations

ALTER TABLE ... ANNOTATIONS ( an1 'val1', an2 'val2' )

These are like comments but better

Want to convert existing comments to annotations?

Here's a script to do it blogs.oracle.com/sql/how-to-c...
December 9, 2025 at 2:21 PM
Reposted by Chris Saxon
🎉 We’re live! The #OracleACE Apprentice program is officially open—welcome to everyone who pre-registered (check your inbox soon!) and all new applicants.
Ready to start your advocacy journey? Learn more & register here 👉
ace.oracle.com/apprentice
December 8, 2025 at 4:59 PM
Congrats to the top 3 players in the Oracle Dev Gym weekly database quiz for Nov

1 Stelios Vlasopoulos
2 mentzel.iudith
3 seanm95

🍾🎉👏

Well done to all who took part

Join the fun and practice your #SQL skills at devgym.oracle.com/pls/apex/f?p...
December 8, 2025 at 3:40 PM
Reposted by Chris Saxon
📚 New Reading List is out!

🎉 #Oracle #AI #Database has been announced for commodity hardware!

🤖 People are busy building agentic apps.

🤓 Happy reading!
Reading List – December 2025 #2
📰 More good reasons to use bind variables in cursors in Oracle - Martin Bach explains what bind variables are and why you should be using them 📰 🤖 Natural Language SQL with Oracle MCP and LangChain4j - Anders Swanson shows how you can build agentic applications with MCP, Oracle Database and Langchain4j 📰 🤖 Can I build an Agent & still use SQLcl’s MCP Server?
www.geraldonit.com
December 8, 2025 at 2:01 PM
Reposted by Chris Saxon
Level Up Your Schema: Annotations for Object Metadata in Oracle AI Database

In Oracle AI Database, annotations provide a powerful way to attach metadata to database objects. Tables, columns, views, and domains are enhanced with self-describing, user-defined assets. This article introduces…
Level Up Your Schema: Annotations for Object Metadata in Oracle AI Database
In Oracle AI Database, annotations provide a powerful way to attach metadata to database objects. Tables, columns, views, and domains are enhanced with self-describing, user-defined assets. This article introduces annotations and how you can start using them to make your data more explainable and AI-ready. Database Annotations Create a Table With Annotations Update Annotations Remove Annotations Example: Use annotations as context for AI Agents with SQLcl MCP Server…
andersswanson.dev
December 5, 2025 at 5:24 PM
Reposted by Chris Saxon
🎉🎉🎉 Big news today and perhaps an early Christmas present.

👉 #Oracle AI #Database #26ai is coming soon for Linux x86-64 on-premises: blogs.oracle.com/database/ora...
December 3, 2025 at 5:25 PM
Reposted by Chris Saxon
It's coming, Oracle AI Database 26ai for on premises commodity hardware announcement

blogs.oracle.com/database/ora...
blogs.oracle.com
December 3, 2025 at 4:30 PM
Reposted by Chris Saxon
Finally … Oracle AI Database 26ai is going to be available on non-Oracle hardware

Many of you have read my blog post from October during Oracle AI World in Las Vegas about Oracle AI Database 26ai replacing Oracle Database 23ai. But the main question remained: When is it available on-prem on…
Finally … Oracle AI Database 26ai is going to be available on non-Oracle hardware
Many of you have read my blog post from October during Oracle AI World in Las Vegas about Oracle AI Database 26ai replacing Oracle Database 23ai. But the main question remained: When is it available on-prem on non-Oracle hardware? It's December now, and Christmas is coming soon, it is time for presents. Yes, finally ... Oracle AI Database 26ai is going to be available on non-Oracle hardware…
mikedietrichde.com
December 3, 2025 at 4:00 PM
The wait is (nearly) over!

Oracle AI Database 26ai EE for Linux x86-64 will be released on premises in the next RU (23.26.1), due January 2026

Read full details at blogs.oracle.com/database/ora...
December 3, 2025 at 4:02 PM
You can build retrieval augmented generation pipelines using #SQL using Oracle AI Database

@domgiles.bsky.social explains at #ukoug2025
December 2, 2025 at 10:36 AM
Heading out on the Oracle ACE Adventure to Cadbury World
November 30, 2025 at 9:58 AM
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
November 28, 2025 at 12:00 PM
Reposted by Chris Saxon
Next: Roel and Alex.
#DOAG2025
November 19, 2025 at 4:24 PM
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
November 19, 2025 at 8:23 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
November 18, 2025 at 10:38 AM
APEXlang is an open application specification language coming for #orclAPEX

This human readable syntax is simple to validate and manage with source control

Mike Hichwa explains how it works at #DOAG2025
November 18, 2025 at 10:20 AM
Oracle AI Database is one Database that supports all data types

You can access the same data as relational tables, #JSON objects, or graph queries

Hasan Rizvi explains at #DOAG2025
November 18, 2025 at 9:11 AM
Reposted by Chris Saxon
How to Sell Data Modeling
Making the Invisible Visible
practicaldatamodeling.substack.com
November 17, 2025 at 4:27 PM
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
November 13, 2025 at 7:13 AM
Reposted by Chris Saxon
QUALIFY Clause in Oracle AI Database 26ai

oracle-base.com/articles/26/...

@OracleDatabase #database #26ai
November 12, 2025 at 7:48 AM
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
November 10, 2025 at 8:21 AM
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