Martin Bach
banner
martindba.bsky.social
Martin Bach
@martindba.bsky.social
Product Manager @ Oracle. Ex @Enkitec. Technology enthusiast. Author, blogger, speaking at user groups. Former Ace Director, OCM. I work for Oracle but do not speak for them
Did you ever play Minecraft? The soundtrack is awesome to listen to when working. Totally helping me to calm down when I’m feeling like I’m too slow getting stuff done. Whoever created it, thank you 🙏

By the way, if you haven’t played Minecraft yet, you should give it a try 😂
November 10, 2025 at 8:32 AM
The sheer horror that is looking at the demos you created 2 months ago with all the best intentions but lacking any notes and other hints how to use them 😖
November 10, 2025 at 7:56 AM
#codetalks2025 coming to a close. It has been a blast, I learned a lot during these days and had a great time. Hoping to be back next year 🤞
November 6, 2025 at 3:38 PM
Day one of #codetalks2025 is about to begin. I’m excited to be part of the agenda, it’s super cool to be here.
Today’s session is about Low Code, CI/CD, databases and how MCP and AI can add value. Care to join us at 11:00 in cinema 2?
November 5, 2025 at 8:48 AM
Reposted by Martin Bach
🔒 Ready to make sense of Oracle Transparent Data Encryption (TDE)? Join #OracleACE Live (FREE) on Nov 12 at 7am PT with Stefan Oehrli for config tips, demos & best practices!
👉 Register: asktom.oracle.com/ords/r/tech/...
October 29, 2025 at 1:04 PM
One more post before October wraps up 🎃

The team got an interesting nut to crack: can you pass JSON PL/SQL types to MLE/JavaScript — and back?

✅ Absolutely, you can!

Here’s how 👉 martincarstenbach.com/2025/10/29/p...

Have fun exploring! 🚀
Passing JSON PL/SQL types to MLE JavaScript
Recently the MLE team was asked if it was possible to pass JSON PL/SQL types to MLE/JavaScript.Remember that you have multiple options to work with JSON in Oracle Database 26ai: SQL (using the JSON…
martincarstenbach.com
October 29, 2025 at 8:22 AM
Reposted by Martin Bach
📚 New Reading List is out!

This week, we take a closer look at #Oracle="/hashtag/Oracle" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link">#Oracle #Database capabilities with a bit of #Oracle #Cloud Infrastructure in the mix.

Happy reading!
Reading List – October 2025 #4
📰 How to write a custom tracer for Oracle Database JDBC - Anders Swanson demonstrates the new Oracle Database JDBC OpenTelemetry provider capabilities 📰 tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates - Tanel Poder has a new script for Oracle Database hybrid histograms 📰 Using Oracle Database Free in your devcontainer and GitHub Codespaces - Martin Bach shows you how to use Oracle Database Free in GitHub Codespaces…
www.geraldonit.com
October 27, 2025 at 1:00 PM
Reposted by Martin Bach
The developer VM has been freshened up! Go get some!
www.oracle.com/database/tec...
October 28, 2025 at 11:43 PM
This is what I call a productive month of blogging…
October 28, 2025 at 2:39 PM
🚀 Oracle AI Database 26 has been released, and it’s packed with exciting updates.

One of the highlights is what’s new in Multilingual Engine. Until now, passing PL/SQL Abstract Data Types between PL/SQL and JavaScript wasn’t possible — but that’s changed!

👉 martincarstenbach.com/2025/10/28/w...
What’s new with MLE 23.26.0 – support for PL/SQL Collections and Records Pt 1
Oracle AI Database has been released! It ships with a whole raft of cool new features, including some the Multilingual Engine (MLE) team integrated for JavaScript. This article discusses one of the…
martincarstenbach.com
October 28, 2025 at 1:33 PM
Reposted by Martin Bach
In the multitenant architecture in Oracle AI Database, the container database is essential. If you create it the right way, you can avoid some difficulties later on.

Here's my recommendation for creating container databases.
How I Think You Should Create Your Container Databases
In the multitenant architecture in Oracle AI Database, the container database is essential. If you create it the right way, you can avoid some difficulties later on. Here's my recommendation for creating container databases.
dohdatabase.com
October 28, 2025 at 6:31 AM
Reposted by Martin Bach
A short summary of the differences between UUIDv4 and #UUIDv7 and an idea how it could be implemented in #Oracle #database. A UUID datatype would be nice 😉.

@oracleace.bsky.social

medium.com/@jasminfluri...
October 27, 2025 at 6:44 AM
It’s the little things sometimes 🙏
Like spinning up Oracle AI Database Free in a container and actually seeing recent improvements in action.
Also, SQLcl 25.3.0 fixed that overflow bug in the CLI — a much cleaner appearence as a result!
Loving these quiet wins. 💡 #Oracle #DevLife
October 21, 2025 at 3:50 PM
Today I revisited a 4yo post on one of SQLcl’s underrated features: autotrace — shows full session stats for a SQL statement (way beyond SQL*Plus). Still works in latest release. Updated prereqs too. More details here
🔗 martincarstenbach.com/2021/06/10/s...
#Oracle #SQLcl #performance #IKYK
SQLcl autotrace is way more than “just” (SQL*Plus) autotrace
As part of the research I did for the 2nd edition of our Exadata book I used session statistics quite heavily. Session statistics can provide additional insights in situations where the wait interf…
martincarstenbach.com
October 21, 2025 at 9:41 AM
Tried to add an Oracle Database to my Dev Containers & Codespaces setup while prepping a Java talk — it was a very smooth experience!

Have a look at my article if you're into modern software development 👉 martincarstenbach.com/2025/10/20/u...

#Java #OracleDatabase #DevContainers #GitHubCodespaces
Using Oracle Database Free in your devcontainer and GitHub Codespaces
Dev containers are pretty nifty when it comes to keeping your development environment isolated from the rest of your system. Quoting from the documentation: Development containers, or dev container…
martincarstenbach.com
October 20, 2025 at 11:42 AM
Reposted by Martin Bach
#DOAG2025: Martin Bach @martindba.bsky.social berichtet in einem Kurz-Interview, warum er immer wieder zu einer der größten Oracle-Konferenzen in Europa nach Nürnberg kommt.➡️ scomp.ly/BkBJ9pJ

Die Anwenderkonferenz

🔗Anmeldung | scomp.ly/YAj48bE
October 17, 2025 at 8:37 AM
It feels weird and great at the same time: writing spring boot apps in Java wasn’t on my bucket list for 2025 but I’m really enjoying it
October 20, 2025 at 7:05 AM
Reposted by Martin Bach
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...
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…
martincarstenbach.com
October 16, 2025 at 1:49 PM
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.
October 16, 2025 at 7:20 AM
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...
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…
martincarstenbach.com
October 15, 2025 at 8:47 AM
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 🥳
October 13, 2025 at 4:04 PM
Reposted by Martin Bach
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
October 13, 2025 at 2:00 PM
Reposted by Martin Bach
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"
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, …
buff.ly
October 10, 2025 at 11:03 AM