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
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