Several years ago I wrote a series of 8 posts about constraint creation optimization. I think it’s time to add some more posts to the series. I showed there, among other things, that Oracle does a…

New in Oracle 26ai: the FILTER clause allows to restrict the rows considered by aggregate functions

So, You Don’t Need Online Upgrades EBR is a set of features that enables patching and upgrading live Oracle-based applications in an online fashion, with zero downtime. If you are responsible for an…

I’ve recently got reminded that assuming something will work, just because it makes sense, doesn’t mean it will really work. While reviewing some code a few days ago, I saw a query of the following fo...

📰 Mixed Feelings About MERGE - DBoriented talks about his "like-dislike" relationship with the MERGE statement and demonstrates some of the statement's nuances. 📰 SQL Plus and SQLcl Formatation Tip for Macbook users - Maicon Carneiro highlights a productivity tip for copy/pasting SQL prompt outputs. 📰 Better support for JavaScript’s console.log() in ORDS handlers - Martin Bach demonstrates Oracle REST Data Services' better handling of JavaScript…

Why Oracle's MERGE Statement Fails Where INSERT/UPDATE Succeeds

YouTube video by SQL and Database explained!

Yet another reason to avoid triggers. A specific case where triggers should be defined on tables rather than editioning views, when using EBR. This case involves foreign keys with the ON DELETE clause...

So, You Don’t Need Online Upgrades EBR is a set of features that enables patching and upgrading live Oracle-based applications in an online fashion, with zero downtime. If you are responsible for an O...

Using SQL to see that 2025 is the only year in the 21st century that is a square number

So, You Don’t Need Online Upgrades EBR is a set of features that enables patching and upgrading live Oracle-based applications in an online fashion, with zero downtime. If you are responsible for an O...

Exactly ten years ago, in November 2014, I gave my first presentation at a conference outside my country and not in my native language. At that point, I already had over twenty years of career experie...