selectlevel,id,parent_id,name,substr(sys_connect_by_path(name,'/'),2)asou
fromisc_baseorg
connectbypriorid=parent_id
startwithid='28D1D9E3E55E49B58E67FA2CEFA58EE2';
--------------
SELECTid,name,d.parent_id,level,substr(sys_connect_by_path(name,'/'),2)asou
FROMisc_baseorgd
CONNECTBYPRI