Last part of my blog series about Implementing Multi-Temporality with Data Vault danischnider.wordpress.com/2026/05/16/i...

New PWOW webinar on Unit Testing & code REUSE is coming! To celebrate, we have a special treat: an exclusive interview with Jacek Gębal, the driving force behind modern utPLSQL (originally founded by Steven Feuerstein). Trade "hope-it-works" for automation! 👇 how2ora-en.blogspot.com/2026/05/who-...

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

The new features guide for Oracle AI Database 23.26.2 is out: docs.oracle.com/en/database/... One interesting addition is the join_to_one clause, which uses integrity constraints to simplify joins.

When integrating systems, we often talk about anti-corruption layers in application code. But what about the database layer? medium.com/@jasminfluri... @oracleace.bsky.social

💯 percent truth! You >must< learn #SQL

Growing void between enterprise and frontier AI puts open weights models in the spotlight www.theregister.com/2026/04/12/a... I keep saying this...

Beautiful! hackingpassion.com/gpubreach-at...

youtube.com/watch?v=mD1g... My favorites: #10 and #1. But all are spot on.

Loops in hierarchical data are a pain Easy to add Hard to prevent @salvis.com shows Oracle AI Database 23.26.1 gives a simple solution Create an assertion limiting the maximum depth to N Do this by joining the hierarchy N+1 times in the assertion

New blog post on how to use the color mix function to create new colors that are derived from the Universal Theme colors. #orclAPEX hartenfeller.dev/blog/apex-mi...

Congrats to the winners of the #OracleACE assertions bounty! 1st Enforcing Acyclic Hierarchies With Assertions @salvis.com 2nd Temporal Assertions @anthony-harper.bsky.social 3rd Assertions for data integrity on a less-than-ideal data model @kibeha.dk Details at blogs.oracle.com/sql/assertio...

Your Java CLI runs locally. But can someone install it with one command? Here’s how to ship it properly: Maven → Fat JAR → JReleaser → GitHub Release → JBang install End-to-end tutorial: buff.ly/TaWDWkK #Java #DevTools #OpenSource #CLI

Reasons why SELECT * is bad for SQL performance: An old blog (with Oracle-specific examples) with a whole range of reasons why. It's not only about network traffic and SQL plan execution, but client side processing and memory usage as well. tanelpoder.com/posts/reason...

Started almost 10 minutes late due to projector issues. They were solved for the next session. Luckily most participants had their laptops ready so I could share my screen via an adhoc Teams conference. Was fun.

Great to see Mister #Oracle 26ai Autoupgrade @dohdatabase.com at the @soug.ch Swiss Oracle Group Meeting in #Switzerland #Bern // @salvis.com - it‘s all about community! @oracleace.bsky.social

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

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

We're still looking for interesting assertions use cases Just over two weeks left for #OracleACE to get your entries in Bounty closes 15th March For full details read blogs.oracle.com/sql/assertio...

Hierarchies should be trees and not loops. Learn how SQL Assertions in Oracle AI Database 23.26.1 can help prevent cycles in hierarchical data. www.salvis.com/blog/2026/02...

SQL-Assertions... I could not resist experimenting. simpleoracledba.blogspot.com/2026/02/draf...

The recording for this session is now avaiable www.youtube.com/watch?v=ulLy...

Java CLIs in 2026: - scaffold with PicoCLI picocli.info - style with Tamboui tamboui.dev - launch with JBang www.jbang.dev - release with JReleaser jreleaser.org

After a decade of planning, editing, delays due to my own busyness, further editing and waiting for 23c, the release of 26ai and my pre-retirement finally unblocked the situation. I have agreed with Apress to publish the third edition of Troubleshooting Oracle Performance in 2026. #TOP3

Finally! Very excited that GitHub is now letting us have controls over who can open PRs on repos. https://github.blog/chan...

I wrote part 2 about what I learned from eight months with Omarchy, especially after switching from macOS after 15 years. I documented which apps I use now on Linux compared to before. Maybe it helps someone here, too. www.ssp.sh/blog/linux-...

Another successful Saturday morning build... :) #Oracle #AI #Database #26ai #Free #Docker

Preventing overlapping start-end dates in history tables is a common challenge Oracle AI Database gives you two ways to do this: Guarantee consecutive ranges with foreign keys Stop overlapping ranges with assertions Find out how in my latest post blogs.oracle.com/sql/how-to-s...

Playing with OracleDB assertions. Learning new error messages. ORA-08673: Equijoin "E"."DEPARTMENT_ID"="D"."DEPARTMENT_ID" found does not meet the criteria to do a FAST validation. Good explanation on docs.oracle.com/en/error-hel...

Rules always have exceptions. In this video I show how to use the --dblinter ignore directive to suppress rule violations for different scopes. youtu.be/5vWUv-jAM14 @united-codes.com #orclAPEX #oracle #plsql #dblinter

Want to improve the quality of your Oracle #SQL and PL/SQL? @salvis.com has built the automatic rule checking suite, dbLinter This defines 187 rules you can apply to check your code Philipp has picked out 14 to always run Do you agree with his list? buff.ly/Nc5t1Qd

I've updated my local APEX development environment to Oracle AI Database 26c. @hartenfeller.dev makes it easy! Thanks!

I did a lot of thinking about the npm supply chain attacks over my break. I wrote up my thoughts, along with some proposed solutions, in my latest post: https://humanwhocodes.co...

Timely for the 🎄 Christmas break, I've put together a more detailed 🛠️ "under the hood" post about extended VARCHARs (VARCHAR2 (32k)) and their often misunderstood 🔢 storage behavior.

I see the dbLinter rules as a large buffet. You choose what you like and what is healthy. But not too much at once. In any case, some rules should be enforced in every project. Do you agree with my top 14? www.salvis.com/blog/2026/01...

Closed a long-running action item from August 2023. The “Coming Soon” page on the Grisselbav website is gone. Replaced with real content. Meet the Grisselbav team virtually at www.grisselbav.com. Happy New Year!

Would you like dbLinter to include a formatter? The more 'thumbs up' we get for the GitHub issue (github.com/Grisselbav/d...), the sooner it will happen.

Do you write and deploy SQL or PL/SQL code for the Oracle Database? Do you care about software quality? If so, you should try dbLinter. It is available in the VS Code Marketplace and the Open VSX Registry.

Oracle AI Database 26ai On-Prem Announced oracle-base.com/blog/2025/12...

It's coming, Oracle AI Database 26ai for on premises commodity hardware announcement blogs.oracle.com/database/ora...

APEX Connect 2026 - Call for Papers noch bis morgen!!! Gebt Euren Abstract den letzten Schliff, und dann ab damit: apex.doag.org/de/home/ Wir freuen uns drauf! 😍 #APEXconn26 #orclAPEX #SQL #PLSQL #solutions #community

Too many commits can kill you! (And everyone else) by @ora600pl.bsky.social at DOAG2025. The summary is the first screen (no slides of course).

If you love your data then you have to love this feature. Presented by @toonkoppelaars.bsky.social who joined Oracle to make that happen. #DOAG2025

Couple here connor-mcdonald.com/2016/03/23/t... asktom.oracle.com/Misc/how-to-...

Some Oracle ACE Program swag waited for me after returning from two amazing days at the ATP Finals in Turin. Useful stuff for #DOAG2025 next week! Thanks @oracleace.bsky.social!

SYSDATE in Oracle AI Database is evaluated once per Statement in #SQL Call in PL/SQL Wrap SYSDATE in a DETERMINISTIC function to trick the compiler into evaluating it once/statement But beware: this can lead to unwanted behaviour @salvis.com explores

SQL trace on Autonomous database connor-mcdonald.com/2025/10/27/s...

I felt like writing a blog post —a little write-up on why fixing failed #database deployments is challenging. Spoiler: The part about undo-scripts might feel like a rant, probably because it is. 🙃 medium.com/@jasminfluri...

Tennis before the first session on day 3 of HrOUG with team „Awesome“ and „OMG“. It was great fun. Thanks! #HrOUG25 #HrOUG2025