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"
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...)
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
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...)
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...)
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 !
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
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 !
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 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?)
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
... and how she has to help-fix every phone, tablet and printer in the hometown when she returns for Xmas.
December 28, 2025 at 12:43 PM
... and how she has to help-fix every phone, tablet and printer in the hometown when she returns for Xmas.
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
Eh.. I do that as well: microwave cups. But a firmware-equipped cup might react badly to microwave.
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
Xmas for "bad" parents?
Reposted by Piet de Visser
I hate how much I enjoyed this
BIG NERD DESIGN ENERGY 🫦
BIG NERD DESIGN ENERGY 🫦
December 13, 2025 at 5:47 PM
I hate how much I enjoyed this
BIG NERD DESIGN ENERGY 🫦
BIG NERD DESIGN ENERGY 🫦
hehehe.
Goede Vraag....
Goede Vraag....
December 10, 2025 at 5:15 PM
hehehe.
Goede Vraag....
Goede Vraag....
True.
(Or, it was like that waay back when i needed crutches in sgp , hel, ams, lhr.. crippled passengers get excellent service)
(Or, it was like that waay back when i needed crutches in sgp , hel, ams, lhr.. crippled passengers get excellent service)
December 9, 2025 at 5:10 PM
True.
(Or, it was like that waay back when i needed crutches in sgp , hel, ams, lhr.. crippled passengers get excellent service)
(Or, it was like that waay back when i needed crutches in sgp , hel, ams, lhr.. crippled passengers get excellent service)
Good Points.
This needs Attention.
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.
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
Good Points.
This needs Attention.
This needs Attention.
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
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
Gets better at every iteration...
November 12, 2025 at 10:13 AM
Gets better at every iteration...
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...
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
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...
No jokes about Devs creating tables.
And having 7 columns with actual names, well, it Is an Improvement over key-integer + payload-varchar2...
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
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
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
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
Useful
And potentially Addictive...
And potentially Addictive...
Click, click and voila! You're connecting from your own machine!
November 10, 2025 at 4:30 PM
Useful
And potentially Addictive...
And potentially Addictive...
how to find (some of the) typos..
just push your text to t' internet.
just push your text to t' internet.
November 9, 2025 at 3:09 PM
how to find (some of the) typos..
just push your text to t' internet.
just push your text to t' internet.
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...
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
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...
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...
Allow me a joke #DBAsRunCronjobs, and cronjobs run the World (and the mail-volume)
November 5, 2025 at 10:15 AM
Allow me a joke #DBAsRunCronjobs, and cronjobs run the World (and the mail-volume)
...up and running.
Thank You for maintaining those !
Thank You for maintaining those !
November 4, 2025 at 6:51 PM
...up and running.
Thank You for maintaining those !
Thank You for maintaining those !
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 )
...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
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 )
...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 )