Martin Bach

Oracle AI Database 26ai replaces Oracle Database 23ai Larry Ellison announced Oracle AI Database 26ai  today in his keynote at Oracle AI World conference in Las Vegas. And I am pretty certain you may want some clarification on what this means exactly.…

Oracle AI Database 26ai replaces Oracle Database 23ai

Read more here:
mikedietrichde.com/2025/10/14/o...

At least in Java/JDBC it’s the same, eg no extra round trip.

Java devs, please instrument your code 🥺 While preparing a talk for Java developers I revisited the topic of code instrumentation. Within the database, for example when writing PL/SQL or MLE/JavaScript code, you would use DBMS_APPLICATION…

Java devs, please instrument your code 🧠
Have you ever struggled tracing SQL back to the app? Use setClientInfo(...) to add meaningful metadata to your JDBC queries. It makes tracing and perf debugging way easier.
New blog post with real code & tips:
🔗 martincarstenbach.com/2025/10/16/j...

Sometimes git status is all you need, but on occasion you want to see _all_ the untracked files, especially if they are hiding in a sub-directory.

git status --untracked-files=all or git status -uall is your friend.

ORA-942 in MLE/JavaScript, but the query runs fine in my IDE! What gives? This article is part of the upcoming Troubleshooting JavaScript chapter that should soon make it into the JavaScript Developer’s Guide. It covers a common problem developers face when writing…

I've been thinking about adding a Troubleshooting MLE/JavaScript chapter to the JavaScript Developer's Guide. I fleshed out one of the drafts today concerning invoker rights/definer rights. The principles apply to MLE just as they do with PL/SQL. Result:
martincarstenbach.com/2025/10/15/o...

Today I was <n> years old when I wrote my first Spring Boot application using JPA/Hibernate and instrumented it via Open Telemetry. I see spans in Zipkin! I probably should be a little less excited but it was too much fun not to be 🥳

Wie verändert AI die Arbeit mit der Oracle Datenbank? Darüber sprechen wir beim nächsten DevTalk am Do. 16.10. – offen und praxisnah.
Mit @martindba.bsky.social (Oracle) & @oraesque.bsky.social
17–18 Uhr, online & ohne Voranmeldung!
👉 meine.doag.org/event/id.939...

#DOAGDevs #DevTalk #AI #KI

Why does my call to json_table return null for a column despite it not being empty? I recently worked on a fun project involving JSON and Oracle Database 23ai. I had to store rather large JSON documents, individual field lengths exceeding what I usually see. No problem with that, …

Convert #JSON to rows & columns with JSON_Table

But if there are errors extracting a field, by default, Oracle Database sets its value to null

@martindba.bsky.social shows how to force an error instead in 23ai with

ALTER SESSION SET JSON_BEHAVIOR="ON_ERROR:ERROR"

I was today years old<an undisclosed number of years old> when I started protecting my default branch on GitHub for my side projects. I hope to avoid silly problems like the one yesterday this way …

Successfully Using SQLcl Projects If Your Production Branch Isn’t Called “main” This short note demonstrates that the the production branch name is configurable in SQLcl projects. If you haven’t come across SQLcl projects yet, it’s Oracle’s opinionated framew…

🚀 New post: Using SQLcl Projects When Your Production Branch Isn’t ‘main’ 🚀

Ran into a configuration issue preparing a demo using a non-standard default branch name.
Luckily, the fix is easy. Full write-up + example here:

👉 martincarstenbach.com/2025/10/08/s...

#Oracle #DevOps #CICD

Intro to Post-Execution Debugging in SQL Developer for VSCode Post-execution debugging has been an integral feature in Multilingual Engine/JavaScript from the very beginning. It allows you to record activity in the database and learn more about your applicati…

SQL Developer for VSCode just got a major upgrade! 🚀

New feature highlight: Post-Execution Debugging — step back through JavaScript in a graphical debugger 🔍

I break it down + how to set it up:
🔗 martincarstenbach.com/2025/10/07/i...

When creating REST APIs what’s your typical response for retrieving data. I quite like the idea in GraphQL where you get an object containing both data and errors - both can be empty.

{
data: […],
error: […]
}

What do you guys do? It’s JSON, though, isn’t it?

A screenshot showing Spotify on my mobile playing the Need for Speed Heat soundtrack

Listening to something more energetic than me this morning to help me finish those slides…. it’s a great, fun game, too, by the way

Using JavaScript to create test data in Oracle Database 23c Previously on @thatjeffsmith... Using JavaScript to create test data in Oracle Database 23c

Previously on @thatjeffsmith... Using JavaScript to create test data in Oracle Database 23c

Thank you! I added your suggestion to the post, with proper attribution of course

Life hack: encode a URL in a QR code using APEX Someone in the community once said to me that APEX is awesome even if you’re not writing APEX apps in the database. It comes with so many useful featues – like the one you’re read…

🔧 Life Hack: you don’t need an external service to generate QR-codes. APEX can do this for you 🤯

In this article I share how I created a QR-code in PL/SQL for use in an upcoming presentation 🖥️ APEX is so much more than a low code platform 🤩

🔗 martincarstenbach.com/2025/10/01/l...

🚀 Found out I needed to resize the root filesystem on my OCI VM while preparing for an upcoming conference. Thankfully it used LVM, so I wrote an Ansible playbook to automate it 🙌 Took me a minute to do, but saved lots of time since.

🔧 Here's how I did it:
martincarstenbach.com/2025/09/30/u...

Unser Oracle Datenbanken Monthly News für September ist jetzt online.
Alle Links zu den News, Events, Release Updates, interessanten Blogs finden sich hier
#oracledatabase #oraclecloud #multicloud #ai #events #oracledba #oracledeveloper

blogs.oracle.com/coretec/post...

Turning off any notifications?

🤖 Oracle Datenbank & KI – was hat es damit nun genau auf sich?

Finde heraus worum es sich beim Thema DB und KI dreht, und zwar beim DOAG Dev Talk am 16.10. – kostenlos & garantiert ohne Buzzword-Bingo!

👉 meine.doag.org/event/id.939...

#Oracle #KI #DevTalk #DOAG

DOAG 2025 Konferenz + Ausstellung: Highlights im Stream "Infrastruktur" Eine Vorstellung der Vortrags-Highlights der DOAG 2025 Konferenz + Ausstellung zum Stream Infrastruktur.

Oh wow, ich habe es mit meinem Vortrag “Ich habe keine Zeit dafür, lass uns das automatisieren“ in die Highlights der @doagev.bsky.social Anwenderkonferenz geschafft 🫣 www.doag.org/de/home/news...

#DOAG2025: Auch dieses Jahr bietet unsere Anwenderkonferenz fast 50 Sessions rund um das Thema #Development. Wir haben die Development-Community befragt und nennen euch einige Highlights aus diesem Stream. ➡️ scomp.ly/0BvYJme

🔗Anmeldung | scomp.ly/YAj48bE
💡Early-Bird-Tickets bis zum 30. September

The other issue I noticed is this: when you try something that’s brand spanking new like the Typescript SDK to create an MCP Server as I did yesterday it turns out the code isn’t particularly good. At this point in time I believe AI is great at explaining things but not yet great at writing.

New DEBUG flag simplifies troubleshooting ORDS container image issues I previously wrote about troubleshooting the ORDS (Oracle REST Data Services) container’s entrypoint, e.g. the script that’s run whenever an ORDS container starts. This older article is…

🚀 New DEBUG=TRUE flag makes ORDS container debugging way easier! 🐳

No more hacks—see exactly what’s happening during startup in ORDS 25.2.3. 💡

Here’s how it works (with live example):

👉 martincarstenbach.com/2025/09/10/n...

#ORDS #DevOps #Oracle #containers

Reading List – September 2025 #1 📰 Oracle Master Encryption Key Management: Wallets, OKV, and HSM Explained - Bryan Grenn shows practical examples of Oracle Database Master Encryption Keys 🎉 Oracle Data Masking and Subsetting expands to discover 150+ new sensitive data types - Oracle adds 150+ new sensitive data types to its Data Masking and Subsetting product 📰 The Magical NVL Function - Więcej Postów demonstrates enhancements for optional SQL query parameters&hellip;

📚 New reading list is out!

🔐 #security, 🩹 #patching, 🎛️ #internals, 🏆 #customerwins and more are part of it.

Check it out! 👇

I doubt I would be able to produce > 400 W for more than one of these intervals 😬

A screenshot showing POUG-style emojis in SQLPlus acting as code delimiters for inline MLE/JavaScript

Maybe POUG style?

I like your way of thinking 🧐

Inline JavaScript and some further details about code delimiters I recently attended POUG 2025, perhaps the most technical conference in Europe with focus on Oracle Database. My friend Øyvind Isene presented about Multilingual Engine (MLE)/JavaScript and made a …

You can define your own inline JavaScript code delimiters in Oracle MLE — even emojis (💥).

A small but useful detail I explored after a great question from @oyvindisene.bsky.social at #POUG2025.

Blog post 👉 martincarstenbach.com/2025/09/08/i...

#oracle #MLE #javascript

🛠️ Just updated: “Implementing DevOps Principles with Oracle Database”

Asked devs: Are you using AI in your CI pipeline?

🧠 Most said: AI happens before the pipeline, not during.
No clear standard—yet.

📄 Dive into the brief: www.oracle.com/a/ocom/docs/...

#DevOps #CICD #Oracle #AI_In_DevOps