例
select ID,OyaID,Level,
sys_connect_by_path(to_char(ID),',') as path
from edaKiri Join dual
on ID not in(3,22)
start with OyaID is null
connect by prior ID = OyaID --亲子条件
order by ID;
1. from句
2. where句 (结合条件)
3. start with句
4. connect by句
5. where句 (行的过滤条件,亲子条件)
6. group by句
7. having句
8. model句
9. select句
10. union、minus、intersect等的集合运算
11. order by句
转载请注明原文地址: https://ibbs.8miu.com/read-2263213.html