1) LISTAGG function WITHIN GROUP- allows you to make, comma separated description
2) Introduced NOCOPY in BLOB/CLOB data types, so that performance can be improved
3) INVISIBLE Index, if we specify it, this is not visible to optimizer
4) SQL ACCESS ADVISOR to give suggestions on Indexes for materialized views, portioned tables
5) Extended composite partitioning ex: LIST – HASH
I will give more in my next post. Keep reading.
Advertisements
