Welcome to oracledoug.com The primary purpose of this site was always to distribute various Oracle-related papers I’ve written and presented at User Group conferences over the years. Alongside those y...

Here’s an example that makes perfect sense if you know how Oracle handles data locking. It’s one that I thought I’d published years ago, but it’s not on the blog and the onl…

How can Britain - and the world - prepare itself for extreme heat?

The most powerful, simple and trusted way to gather experience data. Start your journey to experience management and try a free account today.

Join the Planet Hunters Coffee Chat video series! Project leads cover relevant topics in a friendly, fun format. Want to see what you’ve missed? check out the

Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…

The same capabilities that make OpenClaw a groundbreaking tool also make it an urgent security risk. This blog contains confirmed examples of agent skills being used as malware vectors, and advice on ...

This note isn’t a “real” case study, i.e. it’s not going to show you details of the data, indexes, plans etc. from a production system, but it is modelling one aspect of an …

This note isn’t a “real” case study, i.e. it’s not going to show you details of the data, indexes, plans etc. from a production system, but it is modelling one aspect of an …

Into Barnard's Inn Hall, home of Gresham College.