We're still looking for interesting assertions use cases Just over two weeks left for #OracleACE to get your entries in Bounty closes 15th March For full details read blogs.oracle.com/sql/assertio...

Stretch your #SQL skills with #SQuizL A free guess the SQL statement quiz Every day there's a new Oracle SQL statement to solve in six tries or less Pick from the fragments below to complete the statement on the top left Can you get it in one? buff.ly/hpGFuBa

We're still looking for interesting assertions use cases Just over two weeks left for #OracleACE to get your entries in Bounty closes 15th March For full details read blogs.oracle.com/sql/assertio...

Brand new to Oracle AI Database? Start Here Many Oracle guides are written for DBAs or long-time developers, and as a newcomer it feels like you’re expected to already know the jargon. I started in the same place, learning the as I went, and I’m still learning each day. If you're considering using…

Aggregation Filters in Oracle AI Database 26ai oracle-base.com/articles/26/...

Hierarchies should be trees and not loops. Learn how SQL Assertions in Oracle AI Database 23.26.1 can help prevent cycles in hierarchical data. www.salvis.com/blog/2026/02...

📚 New Reading List is out! This week, we got a lot of great ⭕ #Oracle AI #Database and 🤖 #AI content! 📖 Happy reading!

The recording for this session is now avaiable www.youtube.com/watch?v=ulLy...

You can conditionally filter aggregates in Oracle AI Database 23.26.1 with fn ( col ) FILTER ( WHERE ... ) In earlier releases use fn ( CASE WHEN ... THEN col END ) Both these filter the rows as part of the aggregration Read more in my latest post blogs.oracle.com/sql/conditio...

Calling #OracleACE: we want your assertion use cases! We’re opening a bounty for creative, real-world solutions using assertions Submit your blog post, video, script or slide deck the contribution app by the end of 15 March Full details at buff.ly/fNgDHQv

Great work by the top 3 players in the Weekly DB comp on Oracle Dev Gym for January 1st mentzel.iudith 2st Mahamoutou 3rd Andrey Zaytsev 👏🏆 Thanks to all who took part See the full rankings at devgym.oracle.com/pls/apex/f?p...

In Feb's Ask TOM Live we're looking at fourth normal form: "A table is in 4NF if and only if, for every one of its non-trivial multivalued dependencies X ↠ Y, X is a superkey" To help you understand this, would you prefer A description of these technical terms? Something more informal?

New in Oracle Database #26ai - Aggregation Filters using the FILTER clause in #SQL. db-oriented.com/2026/02/06/a... @oracleace.bsky.social @sym42.bsky.social

Use Oracle FreeSQL.com as a remote test database FreeSQL.com lets you use a free, hosted Oracle AI Database instance right from your browser. But, FreeSQL can also be used as a remote database for testing, POCs, and more! In this article, we'll walk though how to connect to a FreeSQL database from…

Preventing overlapping start-end dates in history tables is a common challenge Oracle AI Database gives you two ways to do this: Guarantee consecutive ranges with foreign keys Stop overlapping ranges with assertions Find out how in my latest post blogs.oracle.com/sql/how-to-s...

Congrats to the winners in the Oracle Dev Gym championships! 1st Andrey Zaytsev 2nd mentzel.iudith 3rd [email protected] 🏆🍾 👏 to all competitors; we hope you enjoyed the challenge Thanks to @kibeha.dk and @anthony-harper.bsky.social for writing & reviewing quizzes blogs.oracle.com/sql/announci...

Exciting news, Oracle AI Database 26ai Container image now available container-registry.oracle.com @oracleace.bsky.social #ACED #oracle #26ai

...aaaaand we're done! Great effort to all who took part; we'll review the results, tally up the scores, and announce the winners in the coming days

The Oracle Dev Gym annual championships are due to start soon! Best of luck to all competitors 🤞

For those unfamiliar, this arrived in 26ai

With assertions in 23.26.1 you can define cross-table constraints Answers can only be submitted while a question is live Every question must have at least one choice Only one choice can be true for single-choice questions Find out how in my latest post blogs.oracle.com/sql/how-to-d...

🎉 #Oracle #AI #Database 26ai Enterprise Edition is now generally available for Linux x86-64 on-prem!

It’s there – Oracle AI Database 26ai is available for download This was a long wait - and finally, it's there - Oracle AI Database 26ai is available for download on-prem. And as you may remember our announcement from Oracle AI World, Oracle AI Database 26ai replaced Oracle Database 23ai. What is…

It's here. Oracle AI Database 26ai On-Prem www.oracle.com/database/tec...

📣 26ai is now available for download, x86-64 bit Linux distributions. www.oracle.com/database/tec...

It's here at last! Oracle AI Database 26ai (23.26.1) Enterprise Edition for Linux x86-64 on premises is GA Once again, there's a host of #SQL updates in this RU. Here are a few to get you started:

OMG ... I can't believe it. It is really gonna happen! #ComingSoon

I'm working on diagrams to visualize how #SQL works Here are examples comparing different options for FETCH FIRST The table at the top is the input Below it are the rows returned for different options for the dots in ORDER BY NUMBER FETCH FIRST ... Which diagram do you prefer? Other comments?

Congrats to 2025's top 3 players in the Oracle Dev Gym Weekly DB quiz 1st Stelios Vlasopoulos 2nd Andrey Zaytsev 3rd mentzel.iudith 🏆🎉 They & the rest of the top 50 players qualify for the annual championships, scheduled for Thurs 29th Jan at 2pm UTC blogs.oracle.com/sql/announci...

Learning #SQL for your 2026 New Year's Resolution? Head to Oracle Dev Gym This has FREE classes to take you from Your first SELECT & CREATE TABLE statements On to recursive WITH and window function queries And learning how to make these fast Join at buff.ly/7gWfOdq

It's been a busy year on Oracle Dev Gym! We've had 430,000+ answers by 14,500+ people Thanks to all who've taken part especially @kibeha.dk & @anthony-harper.bsky.social for writing the Weekly DB quizzes Rajesh Vora for creating Groovy quizzes See you in 2026 devgym.oracle.com/pls/apex/f?p...

Oracle SQLcl Version 25.4 is available, NOW. Improvements for both 👩‍💻 and 🤖!

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...

🎉 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

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...

📚 New Reading List is out! 🎉 #Oracle #AI #Database has been announced for commodity hardware! 🤖 People are busy building agentic apps. 🤓 Happy reading!

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…

🎉🎉🎉 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...

It's coming, Oracle AI Database 26ai for on premises commodity hardware announcement blogs.oracle.com/database/ora...

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…

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...

You can build retrieval augmented generation pipelines using #SQL using Oracle AI Database @domgiles.bsky.social explains at #ukoug2025

Heading out on the Oracle ACE Adventure to Cadbury World

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

Introducing the #Oracle #Database #Documentation #MCP server

Next: Roel and Alex. #DOAG2025

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 ( <query> ) ) @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

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

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