下面是几个例子
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;