Declaring temporary logical query view blocks.
Traversing tree hierarchy data sets like manager-employee tables.
