--专题目录的Tree层级显示 找出顶级节点
select *,substr(aaa,2, INSTR(aaa,'-' ,2,1)-2) from (
SELECT id,PARENT_ID,NAME,
SYS_CONNECT_BY_PATH(id, '-') as aaa
FROM ACCOUNT_UNIT
START WITH parent_id ='3772024'
CONNECT BY PRIOR id = parent_id
ORDER SIBLINGS BY id )
oracle 达梦 tree 找到每个节点找到顶级节点
最新推荐文章于 2024-07-15 18:07:55 发布