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"

589
Followers
319
Following
348
Posts
27.07.2023
Joined
Posts Following

Latest posts by Piet de Visser @pdevisser

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 πŸ‘ 16356 πŸ” 20424 πŸ’¬ 218 πŸ“Œ 350

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

Good Points.
This needs Attention.

13.11.2025 14:13 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

Gets better at every iteration...

12.11.2025 10:13 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

New table added to Schema ...

No jokes about Devs creating tables.

And having 7 columns with actual names, well, it Is an Improvement over key-integer + payload-varchar2...

12.11.2025 09:39 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
SQL Macros
Can factor out common SQL expressions and statements into reusable, parameterized constructs
Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses
Table expressions, used in FROM clauses  to encapsulate calculations and business logic
Scalar macro example

SQL Macros Can factor out common SQL expressions and statements into reusable, parameterized constructs Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses Table expressions, used in FROM clauses to encapsulate calculations and business logic Scalar macro example

SQL Macros
Can factor out common SQL expressions and statements into reusable, parameterized constructs
Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses
Table expressions, used in FROM clauses  to encapsulate calculations and business logic
Table macro example

SQL Macros Can factor out common SQL expressions and statements into reusable, parameterized constructs Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses Table expressions, used in FROM clauses to encapsulate calculations and business logic Table macro example

Macros in Oracle #SQL enable you to define expression templates as text

At parse time the database merges these with the parent query, replacing parameters with the actual values passed

Macros come in two types

Scalar - use in SELECT, WHERE, ORDER BY, etc.
Table - use in FROM

10.11.2025 12:02 πŸ‘ 5 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0