Examination of Neil Chandler’s Post about Adding NOT NULL Columns with DEFAULT values


Neil Chandler has a very interesting post about Adding NOT NULL Columns with DEFAULT values which:

From Oracle 11G, if you: ALTER TABLE table ADD ( column col-type DEFAULT def NOT NULL ) the default isn’t actually added to the data. It’s only added to the meta-data.

Continue reading