About default values on NULL columns, Oracle 11g and 12c have some interesting optimizations : http://www.oracle.com/technetwork/articles/database/ddl-opti...