My mission to learn 12c continues. I’ve been looking at the Identity Column functionality and enhancements to column defaults.
- Identity Columns in Oracle Database 12c Release 1 (12.1)
- DEFAULT Values for Table Columns : Enhancements in Oracle Database 12c Release 1 (12.1)
I know they are not sexy, but these are the sort of enhancements that make me love new versions of the database. Don’t get me wrong, the big changes are interesting too, but these little things make it for me. About 10 minutes after you start using them you almost forget there was ever a time when they weren’t possible. Remember the days before you could drop columns?
These new features resulted in a change to an old article.