select * from (select org_id,org_name,level,substr(SYS_CONNECT_BY_PATH(org_id||'_'||org_name||'_'||level,','),2)
from iap_organization start wITh parent_id is null connect by prior org_id=parent_id) where 1=1
select * from (select org_id,org_name,level,substr(SYS_CONNECT_BY_PATH(org_id||'_'||org_name||'_'||level,','),2)
from iap_organization start wITh parent_id is null connect by prior org_id=parent_id) where 1=1