OU

select level,id,parent_id,name,substr(sys_connect_by_path(name,'/'),2) as ou
from isc_baseorg
connect by prior id=parent_id

start with id='28D1D9E3E55E49B58E67FA2CEFA58EE2';
--------------
SELECT id,name,d.parent_id,level,substr(sys_connect_by_path(name,'/'),2) as ou
FROM isc_baseorg d
CONNECT BY PRIOR id=parent_id
START WITH name='中国南方电网有限责任公司'

SELECT id,name,d.parent_id,level,substr(sys_connect_by_path(name,'/'),2) as ou
FROM isc_specialorg_unit d
CONNECT BY PRIOR id=parent_id
START WITH id='402849815003d443015003d493980139'