Oracle 26ai - UUID v4 available, and looking at v7, Interesting! TL;DR: in Oracle 26ai, there is the new function UUID(), which implements the UUID-V4. Someone also mentioned UUID-V7. I started experimenti...

Oracle AI Databaes 23.9 added a UUID() function

These generates v4 UUIDs

@pdevisser.bsky.social checks it out an looks at methods for generating v7 UUIDs

and thx making me re-read: I found 1 more typo.

How UUIDv7 makes your (database) life easier UUIDv4 has some fundamental limitations for databases, especially at scale. Enter UUIDv7 — an upgrade to make developers’ lives easier.

Thx. My work on UUIDs v4/v7, was sparked by @jasminfluri.bsky.social ,

who wrote:
medium.com/@jasminfluri...

(and I'll repeat: dont put my code into your prod-system without thorough checking!! and preferably do not put/hide/use/depend on "info" in tech-keys)

Feel free Discuss.

Brag moment: new macbook isnt quite quite top-of-specs (M5pro, not M5max). But the extra money for nano-texture screen makes this 1st laptop I can truly use in garden.
Let s see how she holds up...

Should I feel Outdated ?

(the hammer-guys certainly think so, while I keep repeating basic advice on hitting some nails while avoiding others) )

(and I try not to get hit in the process)

The guys with the hammers only want to see nails...

Part of my job is now to control the hammer-guys, make m hit only the right nails in the right way.

(yes, DBA- and Data-wrangler's life... I remember when IT was called "data processing"... )

when ppl take a deep sigh, and state..

"But that datamodel is Normalized..."

(as if that is a bad thing... but yeah, they would prefer 1 single CSV with the cstmr-postcode repeated at every invoice-item-line... )

Agree.
Keep this in mind.

(and it was a nice number to listen to as well)

Eh.. maybe, at the time, some regarded those innovations as horrible and over-the-top papal arrogance as well?

(but I totally agree with Roger)

Food...

Interesting day today...

Looking fw to some smiles this evening...

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

An arc relationship is when a row can reference exactly one of many parent tables

The challenge is when a column in a yet another table defines which is the parent

@pdevisser.bsky.social shows how to use assertions in Oracle AI Database to do this

oh, it is just a one-off... no need to ...

you end up running that one-off for 100s of times, until it is good enough, and you wish you had it properly designed and automated.

Every experienced IT admin eventually learns the same thing.

Nothing is more permanent than a temporary workaround.

On a long trip.. I can use up a rear tyre in 5 weeks...

Thank you after 21 years Throughout my long history of working with the Oracle Database, there are some things that often just take for granted, on the assumption that they have always been present. But there was a time in…

A debt of gratitude owed by many
connor-mcdonald.com/2026/03/12/t...

Just Curious: Any others experimenting with SQL-Assersions ?

#Oracle26ai

Hey Hilversum: kijken jullie mee... ?

most of you know:
There Will Be Typos in the blog.
dont hesitate to tell me...

(bcse the only way to find the typos is to Publish...)

Oracle 26ai with Assertions - a quick look under the cover... TL;DR: Some Very Simple tests of Assertions. Of course I want to know if it has any impact and maybe want to look a little bit closer or ev...

SQL-Assertions in #oracle26ai : They work. They are a Very Powerful feature!).
And you can even see + inspect some the effort that "makes it happen"

/cc
@toonkoppelaars.bsky.social
@oracleace.bsky.social

simpleoracledba.blogspot.com/2026/03/orac...

Some of those errors/warnings, shouldnt they read ora-86nn <something> not supported Yet?

(I ran into similar, and hoping some day, ...)

Who else gets a small kick out of running xeyes..
kids loved it 20yrs ago and still....

In my case, on a container-image, enabling it was...
# dnf config-manager --enable ol8_codeready_builder
# dnf install xorg-x11-apps

For Database-folks: What do you use to draw ERDs ?

(remind me to re-post this on Monday...)

For Database-folks: What do you use to draw ERDs ?

(remind me to re-post this on Monday...)

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

You probably need both.

When done badly, Scrum and DevOps lead to Q+D solutions.
Sometimes you need to step back and “design” your solution.

Imagine an order-shipping system with no “products” and no “customers”, and all data flattened, and endlessly repeated, into orderlines.

These things happen...

Eensch.
Maar een Staatssec is ook mooi.
Nu proberen die Staatssec van goede informatie te voorzien zodat hij/zij af en toe tanden kan laten zien.
Vooral Cybersec, Onafhankelijkheid, en Resilience lijken mij belangrijk.

Agree.