得到组织机构的上下级的数据

select * from fnd_company_levels_t a START WITH a.company_id = '19' CONNECT BY prior a.company_id=a.higher_company_id;

得到ID为19的所有的下级机构

 

     select * from fnd_company_levels_t a START WITH a.company_id = '19' CONNECT BY prior a.higher_company_id=a.company_id;

 

得到下级为19的所有上级的机构