constraints – Learning is not a spectator sport

Silent data corruption – constraints spanning multiple rows

One of the toughest problems in database applications is validation of data that extends “across” rows. We have declarative constraints

When sequences won’t do In an Oracle database if someone comes to you and says “I need to generate unique

This one came in via an AskTOM question. You need to be careful when disabling constraints that are underpinned by

In an Office Hours session a couple of months back, I covered an important change that comes to regular expressions

The DBMS_METADATA package is very cool. I remember the days of either hand-crafting DDL statements based on queries to the

Java and Oracle expert Lukas Eder tweeted yesterday about a potential optimization that could be done when reviewing database SQL

When it comes to giving the cost based optimiser the best possible chance to make the “right” decisions, many DBA’s

I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key

Here’s a very simple example of a table called PARENT being a (surprise surprise) parent in a referential integrity relationship

Having NOT NULL constraints declared on columns that are genuinely not nullable not only is good practice, but can yield