Previously on @thatjeffsmith... I built a mini RAG Pipeline to answer Oracle questions

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

📰 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…

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

Oracle AI Database 23.26.1 is no available as container images

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

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…

Oracle provides more free software than one would think

This book describes the new features in Oracle AI Database 26ai.

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

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

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

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

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

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.

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

YouTube video by Jeff Smith

📰 🤖 OML4Py 2.1 on Linux - Øyvind Isene uses OML4Py to export embedding models into ONNX format 📰 Using the MLE PL/SQL Foreign Function Interface in APEX - Martin Bach shows how to use PL/SQL inside JavaScript Stored Procedures 🏆 ONC Certification of Oracle’s AI-Powered EHR Marks Turning Point for the Healthcare Industry - Oracle Health’s next-generation electronic health record (EHR) is now certified and ready for adoption by ambulatory customers in the U.S…

The Oracle Database is one of the most robust and feature-rich databases available. Naturally, its documentation is vast and frequently updated. Navigating through thousands of pages to find the right information can be time-consuming, even for experienced users. And in the advent of AI, who wants to search the documentation manually for clues anyway? That's where the brand new Oracle Database Documentation MCP server…

While updating my slides covering “what’s new in Oracle AI Database 26ai” I noticed that examples how to annotate views are missing from the SQL Language Reference. While this is …

Oracle AI Database 23.26.0 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free. With this release, 23.8 images have now gone into Unsupported. See the support matrix for more information.

Previously on @thatjeffsmith... QUICKLY access database object metadata via DBMS_DEVELOPER

🎉 Oracle Corporation Announces Promotion of Clay Magouyrk and Mike Sicilia to CEOs - Oracle announced a change in leadership 📰 Pub/Sub with a NodeJS Oracle Database App - Anders Swanson gives you a practical example for Pub/Sub with Oracle Database and JavaScript applications 📰 How To Upgrade 100 PDBs And Move Them To Another Server - Daniel Overby Hansen shows how you can move hundreds of PDBs with just a few commands…

Previously on @thatjeffsmith... How are we (Oracle) doing? Here’s your chance to tell us!

Previously on @thatjeffsmith... Oracle SQLcl 23.3 is now Available for download

Previously on @thatjeffsmith... SQL Notebooks in Oracle SQL Developer for VS Code

Previously on @thatjeffsmith... Come see the Database Tools team at Oracle Cloud/DB World

Oracle's Multitenant architecture allows you to unplug a Pluggable Database (PDB) from one Container Database (CDB) and plug it into another, simplifying database migration and management. This quick guide walks through the process of unplugging a PDB into a .pdb archive file and replugging it into another CDB. We will be using the gvenzl/oracle-free images to demonstrate multiple Oracle Database environments.

SQLcl Projects streamline database deployment with Liquibase, simplifying change management, code automation, and CI/CD integration

Oracle APEX extension for BPMN based workflows

📖 Autonomous DB and OCI: Exporting a Schema to Object Storage + Retention Policy - Marcus Vinicius gives you a detailed guide to back up your ADB schema to object storage 📖 Application and AI Scalability with Oracle Active Data Guard - Ludovico Caldara highlights the many advantages of Oracle Active Data Guard, the leading solution for data protection and more…

For more information on what's new in Oracle Database 23.8, see: What's new for Developers in 23.8 Oracle Database 23.9 has been my favorite RU so far. The features introduced in 23.9 are some of those that we had long had on our list, but simply took a while to get to and to get right. The Non-Positional INSERT INTO…