Advanced Oracle SQL ... in several nutshells

The advanced sql in Oracle can be divided in several categories:

<ol>
<li>Hierarchical sql<br />This is all about the connect by-statement</li>
</ol>

1. Hierarchical sql
   This is all about the connect by-statement
2. Partitioned joins
3. Subquery factoring
   This is all about the with-statement
4. Recursive sql
5. Aggregate sql
   This is all about extensions to the group by-statement: grouping sets, rollup and cube, but also the pivot-statement
6. Analytical or windowing sql
7. Sql modelling