Piet de Visser's Avatar

Piet de Visser

@pdevisser

Database-guy, Typo-maker, Voyager. phd in I told you so, knighthood in... Airport Queues ? Get a motorcycle ! Movie Quotes: "You are a Meaningful and Valued member of ... " "Activate the Omega 13"

590
Followers
319
Following
352
Posts
27.07.2023
Joined
Posts Following

Latest posts by Piet de Visser @pdevisser

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

12.03.2026 02:35 πŸ‘ 9 πŸ” 4 πŸ’¬ 0 πŸ“Œ 0

Just Curious: Any others experimenting with SQL-Assersions ?

#Oracle26ai

09.03.2026 13:24 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Hey Hilversum: kijken jullie mee... ?

08.03.2026 19:27 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

08.03.2026 19:21 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
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...

08.03.2026 19:20 πŸ‘ 4 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

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

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

07.03.2026 08:45 πŸ‘ 0 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0
Post image

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

01.03.2026 15:10 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

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

21.02.2026 13:22 πŸ‘ 0 πŸ” 3 πŸ’¬ 5 πŸ“Œ 0

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

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

21.02.2026 13:22 πŸ‘ 0 πŸ” 3 πŸ’¬ 5 πŸ“Œ 0
Preview
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...

19.02.2026 21:24 πŸ‘ 7 πŸ” 3 πŸ’¬ 0 πŸ“Œ 0

You probably need both.

07.02.2026 06:40 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

05.02.2026 18:59 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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.

05.02.2026 17:46 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Agree.

04.02.2026 18:33 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

hey, Can Never Resist a new Toy.
I got it (downloaded, X11-installed...)
Then tested it (trivially....)

Sometime I feel like holding a shiny new tool, looking for a use-case.
Will try more when time...

Nice job by @toonkoppelaars.bsky.social and @chrisrsaxon.bsky.social

31.01.2026 19:19 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

In solidarity with today's ICE OUT OF MINNESOTA blackout, MinnMax is donating $1 to the Immigrant Law Center of Minnesota for every share of this Bluesky post for the next hour.

23.01.2026 16:01 πŸ‘ 16364 πŸ” 20416 πŸ’¬ 218 πŸ“Œ 351

Thx for the reply.
I know I can add templates. Good tip for BIGFILE.
But what I really wanted was "no template", generate the complete database from (sql-)scripts, starting with CREATE DATABASE, and use all the relevant scripts in $OH/rdbms/admin and others.
(and I know this will take time...)

06.01.2026 12:06 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Yep. the Amazing #Stroopwafel

another hyped dutch export product.

(delicious nevertheless - always carry some when visiting friends. extra points if packaging is from in-house brand like Hema, Jumbo or AH supermarket)

Eet Smakelijk DWPete !

30.12.2025 12:09 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

calling anyone in #Oracle sphere...

cc
@oracleace.bsky.social
@oracleasktom.bsky.social

29.12.2025 10:37 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

#Oracle #v26ai
Anyone intereted in the β€œCREATE DATABASE” purely from Scripts instead of recovering from Template ?
The option seems removed in the currently available 26ai (free, using dbca) version.
Will the (soon) GA release allow to generate scripts ?

(anyone still creating their own?)

29.12.2025 10:35 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image

Electra King

28.12.2025 19:43 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

... and how she has to help-fix every phone, tablet and printer in the hometown when she returns for Xmas.

28.12.2025 12:43 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Eh.. I do that as well: microwave cups. But a firmware-equipped cup might react badly to microwave.

22.12.2025 06:33 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Xmas for "bad" parents?

22.12.2025 06:29 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
744K views Β· 16K reactions | What Using The Internet Is Like In 2025 | Ryan George What Using The Internet Is Like In 2025

This ...

www.facebook.com/reel/8762852...

20.12.2025 08:16 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Video thumbnail

I hate how much I enjoyed this

BIG NERD DESIGN ENERGY 🫦

13.12.2025 17:47 πŸ‘ 6034 πŸ” 1945 πŸ’¬ 104 πŸ“Œ 195

hehehe.
Goede Vraag....

10.12.2025 17:15 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

True.
(Or, it was like that waay back when i needed crutches in sgp , hel, ams, lhr.. crippled passengers get excellent service)

09.12.2025 17:10 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
a close up of a man wearing sunglasses and saying morning . ALT: a close up of a man wearing sunglasses and saying morning .
08.12.2025 05:27 πŸ‘ 2 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0
Preview
a man with a beard sits in front of a laptop ALT: a man with a beard sits in front of a laptop
08.12.2025 05:25 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0