Piet de Visser
banner
pdevisser.bsky.social
Piet de Visser
@pdevisser.bsky.social
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"
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...)
January 6, 2026 at 12:06 PM
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 !
December 30, 2025 at 12:09 PM
December 29, 2025 at 10:37 AM
#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?)
December 29, 2025 at 10:35 AM
Electra King
December 28, 2025 at 7:43 PM
... and how she has to help-fix every phone, tablet and printer in the hometown when she returns for Xmas.
unironically a good idea
December 28, 2025 at 12:43 PM
Eh.. I do that as well: microwave cups. But a firmware-equipped cup might react badly to microwave.
December 22, 2025 at 6:33 AM
Xmas for "bad" parents?
I don’t know how to identify a bad parent anymore. But sweeties, you’re doing great!
December 22, 2025 at 6:29 AM
Reposted by Piet de Visser
I hate how much I enjoyed this

BIG NERD DESIGN ENERGY 🫦
December 13, 2025 at 5:47 PM
hehehe.
Goede Vraag....
nrc.nl NRC @nrc.nl · Dec 10
Fokke & Sukke stellen alleen maar vragen
December 10, 2025 at 5:15 PM
True.
(Or, it was like that waay back when i needed crutches in sgp , hel, ams, lhr.. crippled passengers get excellent service)
This Weeks Editorial Cartoon: Unfairport
Unfairport
theonion.com
December 9, 2025 at 5:10 PM
Good Points.
This needs Attention.
Waar is Europa?

Europa en onze digitale toekomst staan niet tussen de ‘prioriteiten’ waar D66 en CDA nu een agenda voor schrijven.

Nee, deze onderwerpen scoren niet lekker in de peilingen, maar het zijn wel de fundamenten van onze toekomst. En daar moet deze formatie alle aandacht voor zijn.
November 13, 2025 at 2:13 PM
Reposted by Piet de Visser
Je ziet hier altijd gratis onze cartoons. Je kunt ons steunen door onze boekjes te kopen via onze eigen webshop. Ze zijn net zo duur als in de winkel. Maar bij ons kun je ze laten signeren met een tekeningetje... webshop.catullus.nl
Webshop Catullus – Boeken van Uitgeverij Catullus
webshop.catullus.nl
November 11, 2025 at 9:15 AM
Gets better at every iteration...
November 12, 2025 at 10:13 AM
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...
November 12, 2025 at 9:39 AM
Reposted by Piet de Visser
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
November 10, 2025 at 12:02 PM
Useful
And potentially Addictive...
Click, click and voila! You're connecting from your own machine!
November 10, 2025 at 4:30 PM
how to find (some of the) typos..

just push your text to t' internet.
November 9, 2025 at 3:09 PM
Could not resist playing with UUIDs in my Oracle database...
Oracle 26ai can provide UUID-V4.
Soon UUID-V7 ?

simpleoracledba.blogspot.com/2025/11/orac...

Just Playful code....
Dont Use this in Anger..
If you give them a finger they take the whole arm...
simpleoracledba.blogspot.com
November 9, 2025 at 3:09 PM
Allow me a joke #DBAsRunCronjobs, and cronjobs run the World (and the mail-volume)
November 5, 2025 at 10:15 AM
...up and running.
Thank You for maintaining those !
November 4, 2025 at 6:51 PM
When a DBA adds you to their team...
...and in the next 4hrs you receive 180+ mails (from cronjobs...)

Some Things Never Change...
#DBAsRunTheWorld (I have that sticker somewhere.. Thx to @mikedietrichde.com )
November 4, 2025 at 12:15 PM