iiinova — where your digital self keeps evolving

Reposted by Toon Koppelaars

Bjørn Kisbye Engsig @bengsig.bsky.social · 06/07/2026

A heavily updated version 3.3 of the RWP*Load Simulator has been released on Linux and Windows. It includes full raw support, more versatile thread execution, static limits replaced by dynamic allocation and much more. Get it at github.com/oracle/rwloa...

github.com

Release Release 3.3.0 Production · oracle/rwloadsim

This release has a number of changes primarily to rwloadsim itself: The raw data type is now fully operational including several ways to make raw expressions To save memory, variables used in thre...

022

Reposted by Toon Koppelaars

SQLDaily @sqldaily.bsky.social · 09/06/2026

A common defence for storing data as flat tables is: Joins are expensive But is that really true? Thomas Kejser ran performance tests and found Joins are CHEAP when compared with the alternatives This can be true even if you read the whole table buff.ly/AFykOZF

buff.ly

Joins are NOT Expensive! - Raw Reading

Joins are NOT Expensive! - Raw ReadingWhen talking about Data Lakes and how people access them - we must address some of the misconceptions that made them popular in the first place.

032

Toon Koppelaars @toonkoppelaars.bsky.social · 18/05/2026

My venue this afternoon. Come join my session at 3PM on 26ai assertions new feature. #apexconn26

174

Reposted by Toon Koppelaars

Niall Litchfield @nlitchfield.bsky.social · 08/05/2026

A marvellous LinkedIn post (no really) from a colleague of mine on one of the promises of AI. Those of you who know my sense of humour, or have ever engaged with the old Oak Table folks, will probably appreciate it. www.linkedin.com/pulse/2-mill...

linkedin.com

075

Toon Koppelaars @toonkoppelaars.bsky.social · 06/04/2026

Where's Wolowitz when you need him?

010

Toon Koppelaars @toonkoppelaars.bsky.social · 22/03/2026

Another weekend of just-in-time presentation creation for a user-group...

150

Reposted by Toon Koppelaars

Franck Pachot @franckpachot.bsky.social · 01/03/2026

I updated my SQL Assertion article with some maths and added the ALL ... SATISFY syntax that avoids double NOT EXISTS in Oracle Database SQL Assertions dev.to/franckpachot...

1463

Reposted by Toon Koppelaars

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 06/03/2026

Assertions for data integrity on a less-than-ideal data model. www.kibeha.dk/2026/03/asse... Or "How I could have used assertions 25 years ago when I worked with Concorde XAL"... #OrclDB #SQL #Assertions #OracleACE

kibeha.dk

Assertions for data integrity on a less-than-ideal data model

25-30 years ago I worked a lot with the Danish developed ERP system called Concorde XAL. It ran on top of a database (choice of several, mos...

275

Reposted by Toon Koppelaars

Philipp Salvisberg @salvis.com · 09/03/2026

How do you enforce temporal data integrity? With SQL Assertions in Oracle AI Database, we can now implement constraints such as: ✅ Non-overlapping validity periods ✅ Temporal referential integrity Here's a practical example using an extended DEPT-EMP model. www.salvis.com/blog/2026/03...

salvis.com

Using SQL Assertions to Enforce Temporal Data Integrity

Introduction More than twelve years ago, I described the multi-temporal features of Oracle Database in this blog post. In the conclusion, I wrote that I missed a temporal DML API, temporal integrity c...

053

Reposted by Toon Koppelaars

Chris Saxon @chrisrsaxon.bsky.social · 27/01/2026

Assertions Define cross-row, cross-table constraints with simple SQL: CREATE ASSERTION ... CHECK ( <rule> ) Use this to enforce rules like * No overlapping start-end dates * Every parent row must have a child row (invoices must have an invoice line)

Assertions (23.26.1)

Declare cross-row, cross-table constraints with simple SQL
Use existential ([NOT] EXISTS) expressions to define rule

Example to prevent overlapping job history ranges

Assertions (23.26.1)

Declare cross-row, cross-table constraints with simple SQL
New universal expressions (ALL-SATISFY) as a clearer way to express rules that apply to every row

Example to prevent overlapping job history ranges

131

Toon Koppelaars @toonkoppelaars.bsky.social · 27/01/2026

Keep hitting ORDS-22001, what's the thing I'm missing? - I've granted my procedure to everyone - I've used ords_admin.add_plsql_gateway_procedure to add it - I've added it to wwv_flow_epg_include_mod_local Any ideas? @alexnuijten.bsky.social @apexconsulting.nl

100

Reposted by Toon Koppelaars

Connor McDonald on Database and SQL @connormcd.bsky.social · 07/10/2025

A little known about SQL feature... being able to "bring along extra columns" when you aggregate.

081

Toon Koppelaars @toonkoppelaars.bsky.social · 16/09/2025

Apart from the funny pronounciation of SQL, a pretty good summary of history here. www.youtube.com/watch?v=lvCZ...

youtube.com

The Untold Story of Databases

YouTube video by CodeSource

021

Toon Koppelaars @toonkoppelaars.bsky.social · 25/08/2025

I noticed different people use the terms "inner" and "outer" table/rowsource differently for NL-joins. Never liked the terms myself: I always use 1st table/rowsource and 2nd table/rowsource when discussing NL-joins. And for HASH-joins: build and probe.

210

Reposted by Toon Koppelaars

Chris Saxon @chrisrsaxon.bsky.social · 13/05/2025

Oracle Database Free 23.8 is now available Get it at www.oracle.com/database/fre... This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL: Enhanced dynamic stats for PL/SQL in FROM & WHERE This can be particularly useful for estimating pipelined table functions

Dynamic stats for PL/SQL functions (23.8)
Improve row estimates for PL/SQL functions in SQL with dynamic stats
By default row estimates for pipelined table functions are poor

Dynamic stats for PL/SQL functions (23.8)
Improve row estimates for PL/SQL functions in SQL with dynamic stats
With dynamic PL/SQL stats in 23.8, get accurate row estimates for pipelined functions

12512

Toon Koppelaars @toonkoppelaars.bsky.social · 04/05/2025

Morgen 80 jaar geleden, verloor mijn vader (nu 90) één van zijn zussen. Zijn ouders hadden gehoord dat NL bevrijd was en gingen met 'n roeiboot met hele gezin van boord naar de wal, om 't te vieren. Een paar Duitse soldaten op de dijk hadden het bericht nog niet gehoord, en schoten op de roeiboot...

020

Toon Koppelaars @toonkoppelaars.bsky.social · 24/04/2025

Omg... Looks like I'm going to Poland :-)

1172

Reposted by Toon Koppelaars

Piet de Visser @pdevisser.bsky.social · 18/04/2025

Recognizable. Mandatory Reading for IT folks....

031

Toon Koppelaars @toonkoppelaars.bsky.social · 24/03/2025

Just submitted my first abstract for POUG. Now we sit and wait...

050

Reposted by Toon Koppelaars

Roel @apexconsulting.nl · 18/03/2025

Some more details on the SQL Assertions feature. New language construct to get used to 😉.

0187

Reposted by Toon Koppelaars

Erik van Roon @evrocs.bsky.social · 18/03/2025

The (near) future of data integrity in the Oracle database is looking beautiful thanks to @toonkoppelaars.bsky.social and his team.

1188

Reposted by Toon Koppelaars

nlOUG @nloug.bsky.social · 18/03/2025

Feature X session tonight in a (almost) sold-out room. This feature coming soon. There is another chance to learn more about this feature at #apexworld25 this Friday! nloug.nl/events/apex-...