Adding NOT NULL Columns with DEFAULT values – 11G

(Neil Chandler) In Oracle, if we add a column to a table which is NOT NULL, we are allowed to do it directly, in a single statement, as long as we supply a DEFAULT value to populate any pre-existing rows.

Read More - Register for Free Membership