Nodes Branches « Hierarchical Query « Oracle PL / SQL






1.Eliminating Nodes and Branches from a Hierarchical Query
2.Eliminate an entire branch of nodes from the results of a query, you add an AND clause to your CONNECT BY PRIOR clause