Lightnews — Scholar-powered news

Reposted by Martin Bach

SQLDaily @sqldaily.bsky.social · 1h

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

1

Martin Bach @martindba.bsky.social · 3h

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 …

Martin Bach @martindba.bsky.social · 1d

🚀 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

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…

martincarstenbach.com

2

Martin Bach @martindba.bsky.social · 3d

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

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…

martincarstenbach.com

2

Martin Bach @martindba.bsky.social · 4d

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?

1

Martin Bach @martindba.bsky.social · 8d

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

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

Reposted by Martin Bach

Jeff Smith @thatjeffsmith.com · 8d

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

Using JavaScript to create test data in Oracle Database 23c

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

www.thatjeffsmith.com

1

Martin Bach @martindba.bsky.social · 9d

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

1 1

Martin Bach @martindba.bsky.social · 9d

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

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…

martincarstenbach.com

1 3 5

Martin Bach @martindba.bsky.social · 10d

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

This link will take you to a page that’s not on LinkedIn

lnkd.in

Reposted by Martin Bach

Ulrike Schwinn @uschwinn.bsky.social · 14d

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

blogs.oracle.com

1

Martin Bach @martindba.bsky.social · 14d

Turning off any notifications?

1 2

Martin Bach @martindba.bsky.social · 14d

🤖 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

Events - DOAG

meine.doag.org

3 2

Martin Bach @martindba.bsky.social · 27d

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

DOAG 2025 Konferenz + Ausstellung: Highlights im Stream "Infrastruktur"

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

www.doag.org

3

Reposted by Martin Bach

DOAG e.V. @doagev.bsky.social · 28d

#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

2 3

Martin Bach @martindba.bsky.social · 27d

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.

1 2

Martin Bach @martindba.bsky.social · 29d

🚀 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

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…

martincarstenbach.com

1 3

Reposted by Martin Bach

Gerald Venzl @gvenzl.bsky.social · Sep 8

📚 New reading list is out!

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

Check it out! 👇

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…

www.geraldonit.com

3 3

Martin Bach @martindba.bsky.social · Sep 9

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

1

Martin Bach @martindba.bsky.social · Sep 8

Maybe POUG style?

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

1

Martin Bach @martindba.bsky.social · Sep 8

I like your way of thinking 🧐

Martin Bach @martindba.bsky.social · Sep 8

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

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 …

martincarstenbach.com

2 3 8

Martin Bach @martindba.bsky.social · Sep 2

🛠️ 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

www.oracle.com

1 2

Martin Bach @martindba.bsky.social · Sep 1

I’m so in love with `git stash` and `git stash pop`. So convenient for people like me who occasionally get off track while multitasking 🫣

3

Martin Bach @martindba.bsky.social · Aug 19

🚀 Question to the Tech Community 💻

Are you integrating AI-powered tools into your DevOps CI/CD pipeline?

🤖 Do you believe they truly belong in the pipeline, or are they better suited for development and local testing only?

I’d love to hear your thoughts! 💬

1