oracle 递归查询整个路径并行转列组合成字符串

发布时间：2020-12-12 13:53:39 所属栏目：百科来源：网络整理

导读：递归查询路径： select * from t_db_organize connect by prior fartherid=id start with id= '139312' order by id asc 行转列： select replace (wm_concat(to_char(name)), ',' , ' ' ) name from ( select * from t_db_organize connect by prior farthe

递归查询路径：

select * from t_db_organize connect by prior fartherid=id start with id='139312' order by id asc

行转列：

select replace(wm_concat(to_char(name)),',',' > ') name from(select * from t_db_organize connect by prior fartherid=id start with id='139312' order by id asc);

wm_concat：行转列，默认逗号分隔，中文会乱码，使用to_char可以避免

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!