Oracle Recursive Tree

Example Download:

Http://yunpan.cn/cLY4v5hdQeMY6 (Extract code: AE65)

Grammar:

Select ... from <TableName>
where <Conditional-1>//filter
start with <Conditional-2>//recursive starting point
Connect by <Conditional-3>; Connection Qualification

Attention:

1,Prior placed on the child node side, it means that the scan tree is the start with the node specified as the root node from the top down scan

2,Prior placed on the parent node, it means that the scan tree is the start with the specified node as the lowest layer of child nodes, from the bottom up scan.

3, remove prior keyword means no recursion

example:

Oracle Recursive Tree