Blogging right from Tom's session "database new features". Here are the new features as they are discussed:
1. Identity Columns
Remember I blogged on this topic earlier.
2. Default on null
A default value is inserted into the column When it's null.
3. Improved defaults - metadata only defaults
Now add new default columns to a table on the fly. 12c does that for you.
4. Increased size limit for Varchar2 and NVarchar2
The column types can be upto 32k.
5. Row Pattern Matching
Efficient SQL functionality for reporting row patterns like identifying V and W patterns for your stock
6. Partitioning Improvements
Online partition movement without using DBMS_REDEFINITION. Efficient global index management during DROP and TRUNCATE partition operation.
7. Hybrid Histograms
Jonathan Lewis spoke on this topic. I think more information on this is available on his blog.
8. Session private statistics for GTTs
Table and index statistics are held private for each session.
9. Temporary UNDO
Undo for temporary tables can now be managed in TEMP. Reduces the amount of undo generated in undo tablespace and redo generation.
10. Pluggable databases
Read Roels blog for this one. He has a good blog post on this