connect by prior connect by prior document. CONNECT BY hierarchical query document. connect by prior Connect by connect by prior hierarchical query. connect by prior hierarchical query in Oracle Hierarchical Queries