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

2012-12-28

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