Loic Lefevre

Assertions used in arc-relationship TL;DR: A simple use-case for SQL-Assertions: Adding a data-related constraint to an arc-relation. Demo using the Emp-Dept schema. Summary u...

SQL-Assertions...
I could not resist experimenting.

simpleoracledba.blogspot.com/2026/02/draf...

Reading List – February 2026 #2 📰 Dealing with TNS database connections with Oracle MCP (SQLcl) - Jeff Smith explains how to connect your MCP server via TNS names 🎉 Announcing the winners of the 2025 Oracle Dev Gym Championships - Oracle announced the 2025 Dev Gym Championship winners 🎉 Ascend to the Diamond Tier: Introducing the Next-Gen Oracle Maximum Availability Architecture (MAA) - Oracle introduced a new top-level for its Maximum Availability Architecture…

📚 New Reading List is out!

This week, people dug into all sorts of new 🅾️ #Oracle #AI #Database features - definitely a must read to get you up to speed, and we got a couple of really 🤩 🎉 exciting announcements!

📖 Happy reading!

Analyse : l’Ademe est-elle bien gérée ? Un tir groupé, et organisé. Depuis deux ans, de très nombreux responsables politiques mettent en cause l’utilité et l’efficacité de l’Ademe

L'Ademe est-elle bien gérée ? De très nombreux responsables politiques et éditorialistes mettent en cause l’utilité et l’efficacité de l’Ademe et demandent sa suppression.
On a étudié le sujet, avec des faits des sources fiables. Par @thibautschepman.bsky.social : bonpote.com/agence-ademe...

Oracle AI Database 23.26.1 Free multi-platform images now available on gvenzl/oracle-free Oracle AI Database 23.26.1 is no available as container images

#Oracle #AI #Database #Free 23.26.1 is now available on gvenzl/oracle-free

Happy 🐳

Oracle AI Database 26ai On-Prem Installations

oracle-base.com/blog/2026/01...

Oracle AI Database 26ai Enterprise Edition now GA for on-premises Linux x86-64 Oracle AI Database 26ai Enterprise Edition is now generally available for Linux x86-64. You can download it from the usual places, such as the Oracle Database download page, Software Delivery Cloud (eDelivery), and My Oracle Support (the RU). Check out the Oracle AI Database New Features Guide to see all the new features that came in this release. …

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

Oracle AI Database 26ai for Linux x86‑64 is finally here - and with AutoUpgrade, setting it up is easier than ever.

www.martinberger.swiss/posts/2026/2...

@oracleace.bsky.social @dohdatabase.com @mikedietrichde.com

#community #curiosity #passion #38743961 #38842609 #6880880

Retrieving the result of a PL/SQL computation in MLE/JavaScript Recently, while working on a joint project with the APEX team, the need arose to rewrite a piece of PL/SQL code in MLE/JavaScript. The PL/SQL code in question roughly looks like this. declare l_res…

The best way to get ideas for blog posts is to actively work with technology 💻. I love experimenting 🧪👨‍💻
Recently I translated a PL/SQL code unit to MLE/JavaScript. If you ever need to perform a PL/SQL calculation in JavaScript⚙️, here’s how to do it 👇

martincarstenbach.com/2026/01/21/r...

Great free software from Oracle Oracle provides more free software than one would think

Did you know that #Oracle provides a lot of #free software?

Don't believe me? Read on to find out more!

Hmmm, wondering if this new QUALIFY clause for Oracle 26ai would interest @lukaseder.bsky.social 🤔

docs.oracle.com/en/database/...

Oracle Database blogs to add to your RSS feeds Previously on @thatjeffsmith... Oracle Database blogs to add to your RSS feeds

Previously on @thatjeffsmith... Oracle Database blogs to add to your RSS feeds

Support for Transportable Tablespaces on Oracle Autonomous AI Database Serverless – Testing with OCI Object Storage

alexzaballa.com/support-for-...

🤩 My preferred feature lately! Save your scripts as .sqlnb and enjoy

Reading List – December 2025 #4 🎉 Introducing OCI Ampere A4 Standard: Next-Generation Arm-Based Cloud Compute for Performance and Efficiency - Oracle introduces new OCI instance shapes with Ampere A4 Standard CPUs 📰 Insufficient privileges and PL/SQL - Javier Carreras explains the security context change with PL/SQL and the implied privilege model 📰 🤖 Your favorite Oracle database CLI and MCP just got updated - Jeff Smith highlights some of the new features in the latest version of SQLcl…

📚 New Reading List is out!

This week, we got lots of interesting news regarding 🤖 #AI, ☁️ #OCI and ⭕ #Oracle #Database.

The next two weeks (I) will take a break, so see you back in 2026.

📖 Happy reading and 🎄 Happy Holidays!

Build an MCP to connect AI to Oracle Database w/OpenAPI Previously on @thatjeffsmith... Build an MCP to connect AI to Oracle Database w/OpenAPI

Previously on @thatjeffsmith... Build an MCP to connect AI to Oracle Database w/OpenAPI

Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6 Previously on @thatjeffsmith... Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6

Previously on @thatjeffsmith... Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6

And you also could mention another advantage for enterprises having Exadata infra: vector search offloading works well

blogs.oracle.com/exadata/exad...

yes, since you talk about vectors (26ai), then if [not] exists clause is available

you could use:

drop <object type> if exists <name>;

ICYMI, ORDS 25.4 is available for download and being updated across the Autonomous fleet. Link: www.oracle.com/database/sql...

We've updated our image in the Oracle Container Registry, made doc improvements, and added fixes too. Release Notes: www.oracle.com/tools/ords/o... #newrelease #ords #apis

and ... we're in!

Details on Jeff's blog
www.thatjeffsmith.com/archive/2025...

Your favorite Oracle database CLI and MCP just got updated Previously on @thatjeffsmith... Your favorite Oracle database CLI and MCP just got updated

Previously on @thatjeffsmith... Your favorite Oracle database CLI and MCP just got updated

dbLinter is Officially Out of Preview: Now Available | United Codes Blog dbLinter has exited preview and is now fully available. Get a license to share configurations with your team and integrate it into pipelines via the CLI.

dbLinter is released 🥳🥳 #orclAPEX

blog.united-codes.com/post/dblinte...

Reminds me this 10g-non-event migration where every single column of the 1000+ tables app was controlled regarding histogram computation: we had a table describing for each column, its histogram gather method.

that's at that time I understood that execution plans should be part of your git repo...

...meanwhile, listening open.spotify.com/track/4rwpnF...

Big milestone today! ‼️

We have officially opened the #Oracle #ACEApprentice program! 🎉 🎉 🎉

Never was learning to be an advocate so much fun! 🧑‍🎓

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

Code & Tune an Oracle DB REST API w/Claude, MCP, & ORDS Previously on @thatjeffsmith... Code & Tune an Oracle DB REST API w/Claude, MCP, & ORDS

Previously on @thatjeffsmith... Code & Tune an Oracle DB REST API w/Claude, MCP, & ORDS

YouTube video by Jeff Smith Chatting with your Oracle AI Database with our MCP Server

A video you can watch whilst pretending to work today.

Interacting with your Oracle AI Database from your AI Agent via MCP ... NO SLIDES

www.youtube.com/watch?v=nXro...

incredible experience: clicking on the link Jeff starts speaking french!!! well french canadian in fact, how weird it was...