根据一个ID,查询到该ID上所有的子级ID

根据一个ID,查询到该ID下所有的子级IDselect * from r_organization_dimension start with id20081 conne

根据一个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