Question

oracle递归查询的问题，如何查询出现机构和其属下所有机构

表结构:
gias_org{orgid,fatherorgid,orgname}
需求如下：
输入的orgid为1，那么就查询出orgid为1的机构和其所有下属机构

Answer 1

select *
from table_name
where 1 = 1 --没有条件可以不写where
connect by parent_id = prior child_id
start with parent_id = 1

Answer 2

select orgid,fatherorgid,orgname
from gias_org
start with fatherorgid= 1
connect by prior orgid= fatherorgid
--如果需要排序
order siblings by 要排序的字段

Answer 3

select * from gias_org where fatherorgid =1 and orgid=1;

Answer 4

试试这个

select orgid,fatherorgid,orgname
from gias_org
start with orgid = 1
connect by prior id = fatherorgid