select ltrim(max(sys_connect_by_path(name,'-')),'-') from dbtree start with dbtree.id=36 connect by prior dbtree.p_id=dbtree.id
如上sql,出来的结果是: 综合,文书类
我要的结果是: 文书类,综合
...全文
6295打赏收藏
sys_connect_by_path连接的字符串顺序反了?
select ltrim(max(sys_connect_by_path(name,'-')),'-') from dbtree start with dbtree.id=36 connect by prior dbtree.p_id=dbtree.id 如上sql,出来的结果是: 综合,文书类 我要的结果是: 文书类,综合