Filters in the JOIN Clause vs. WHERE Clause: Does It Matter?

Here’s a question I’ve been asked multiple times from multiple people: “Does it matter I put filters in the join clause vs in the WHERE clause?  And if so, which one is better?” Example: vs. So does it matter? Answer:… Read More

How to Install Oracle 19c on a DigitalOcean Droplet Without ASM (Easiest Install Ever With Tons of Pictures)

If you don’t already have a DigitalOcean account, you’ll want to use this link here to sign up: https://m.do.co/c/97b9d595c7d3 If you use the special link above to sign up, you will get $100 of credit over a 60-day period. Disclaimer… Read More

Summing Interval Data Types

Something I’ve occasionally thought would be really nice is if Oracle had a good way of summing interval data types, much the same way that you can SUM() number data types.  Occasionally I’ve designed processes that record start and stop… Read More