Top New Features As Used by Me
Subquery Factoring aka WITH clause
What a surprise such the useful clause has been ignored by me until now. And it is here since 9i. I found it in a book "
Cost Based Oracle: Fundamentals" by
Jonathan Lewis. There is an in-depth article at
Oracle-Base about the feature.
Virtual Columns
The virtual column is an extra column in a table which can be a result of calculation based on existing real columns. It came with Oracle 11g and simplified queries very much. It can be used for table partitioning,
