oracle树遍历where,Oracle 中的树查询和 connect by

1. 从根到叶遍历SELECT n_parendid, n_name, (LEVEL - 1), n_id

FROM navigation

WHERE n_parendid IS NOT NULL

START WITH n_id = 0

CONNECT BY n_parendid = PRIOR n_id;2. 从叶到根遍历SELECT n_parendid, n_name, (LEVEL - 1), n_id

FROM navigation

WHERE n_parendid IS NOT NULL

START WITH n_id = 300

CONNECT BY n_id = PRIOR n_parendid;3. 排除个体，但不排除它们的子孙SELECT n_parendid, n_name, (LEVEL - 1), n_id

FROM navigation

WHERE n_parendid IS NOT NULL AND n_id != 2

START WITH n_id = 0

CONNECT BY n_parendid = PRIOR n_id;4. 消除个体和它所有的子孙SELECT n_parendid, n_name, (LEVEL - 1), n_id

FROM navigation

WHERE n_parendid IS NOT NULL

START WITH n_id = 0

CONNECT BY n_parendid = PRIOR n_id AND n_id != 2;5. 改变显示顺序SELECT n_parendid, n_name, (LEVEL - 1), n_id

FROM navigation

WHERE n_parendid IS NOT NULL

START WITH n_id = 0

CONNECT BY n_parendid = PRIOR n_id

ORDER BY n_viewnum DESC;