根据一个ID,查询到该ID下所有的子级ID
select * from r_organization_dimension start with id=20081 connect by nocycle prior id=parentid
r_organization_dimension表结构
id 子级ID
parentid 父级ID
发布时间: 2012-12-28 10:29:05 作者: rapoo
根据一个ID,查询到该ID下所有的子级ID
select * from r_organization_dimension start with id=20081 connect by nocycle prior id=parentid
r_organization_dimension表结构
id 子级ID
parentid 父级ID