Level « Hierarchical Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Hierarchical Query
  3. Level
1.Using the LEVEL Pseudo-Column:display the level in the tree
2.Use the COUNT() function and LEVEL to get the number of levels in the tree
3.Traversing Upward Through the Tree
4.sort by LEVEL
5.pseudocolumn LEVEL and an example of using the levels with an update.
6.pseudocolumn LEVEL and an example of using the levels.
7.Browse Products with three level nested queries