(connormcdonald) One of the cool things in 12c is that (finally after all these years) a sequence can be assigned as the default value for a column.

(Hemant K Chitale) Unlike Table Compression that uses deduplication of column values, Index Compression is based on the keys. Key Compression is also called Prefix Compression.

(Kellyn Pot’Vin) This question was posted in Twitter from @matvarsh30, who asked, “How can I display CPU usage over different periods of time for databases in Enterprise Manager?”

(Richard Harrison) When looking for the latest PSU’s for 12.1.0.2 this week i noticed that the names have been changed (to protect the guilty…?).

(mdinh) Just a quick note to demonstrate how to convert date range partition into interval partition.

(connormcdonald) We’ve (hopefully) all had it drummed into us enough times – you cannot assume the order of results from queries unless you explicitly include an ORDER BY statement.

(Lucas Jellema) Well organized exchange of client side events has been something of a holy grail for client side web development to me. I do not like these direct interactions between components that should not even know about each other. On the other hand – earlier this week I could not find out ho

(David Fitzjarrell) Dates are, well, dates. They are not strings, they are not numbers, they are dates and to handle them properly the correct data type needs to be used.

(connormcdonald) A while back I did a blog post showing that when you have set a column to UNUSED, it still “counts” as a validation step when doing exchange partition.

(Thomas Saviour) Oracle PARTIAL INDEXES – a new feature in Oracle 12c, initial impression was really good, but the implementation is quite poor. With this feature, you can define INDEXING OFF for a partition so that any index with PARTIAL clause will skip this partition while creating the index.