It’s a common mistake: a company puts a poorly performing database on larger and larger servers, throwing more and more money away while making the same mistakes, but the database never gets any ...

When is a database not a database? When it is a spreadsheet. What do spreadsheets have to do with databases do you ask? Spreadsheets are actually very rudimentary databases and, while not advisable, ...

In particular, I often look up constraints in SQL*Plus. In this post, I look at the Oracle database views and queries that I use most to get an idea what constraints I am dealing with. Topics ...