Hierarchical Queries « Query Select « Oracle PL/SQL Tutorial

2.40.Hierarchical Queries
2.40.1.Hierarchical Queries
2.40.2.Using the CONNECT BY and START WITH Clauses
2.40.3.Formatting the Results from a Hierarchical Query
2.40.4.Starting at a node other than the root
2.40.5.Traversing Upward Through the Tree
2.40.6.Eliminating Nodes and Branches from a Hierarchical Query
2.40.7.Add where clause to a Hierarchical Query
2.40.8.employee tree: who is my manager
2.40.9.Output full path of hierarchy

2.40.11.pseudocolumn LEVEL and an example of using the levels.
2.40.12.pseudocolumn LEVEL and an example of using the levels with an update.