I've seen this far too often. A table with a primary key (good) and a check constraint (NOT NULL) on the same column. Stop doing it. W...

Just in case you ever forget what the 5 constraints in an Oracle database are...

A slightly different way of putting that is Surrogate vs. Natural keys. Not that I really want to get into the entire discussion...but I wil...

I ran across this question today on the Oracle-l list: Hi List, I have read the following but I am looking for a way to create a case-insen...

Yesterday while perusing the Concepts Guide , I stumbled across the ENABLE NOVALIDATE keywords for the definition of a Foreign Key constrai...

I've been reading about this phenomenon for years over on asktom , but I had never actually encountered the problem, until today that is...

Also known as reference, crosswalk and a few other names. I love 'em. I'm not afraid to use them. It certainly makes that table cou...

Continuing on the theme of late, what are the basic things that you can do to reduce the amount of code that needs to be written? In the po...

Dom Brooks recently posted an article about the Dea(r)th of the Oracle RDBMS . It seemed to struck a chord. I've written about MySQL Fr...

Tables are easy. CREATE TABLE t ( col1 NUMBER(10,0) CONSTRAINT pk_col1 PRIMARY KEY, col2 VARCHAR2(32) CONSTRAINT nn_col2_t NOT ...

Today one of my more feisty colleages and I had a discussion about constraints. I had asked him if he wouldn't mind naming the NOT NULL ...