Oracle函数:sys_connect_by_path 主要用于树查询(层次查询) 以及 多列转行
SELECT T.C_PK_ID, T.C_TESTDATA_NME, sys_connect_by_path(C_TESTDATA_NME,‘/‘), LEVEL FROM WEB_UI_TESTDATA T WHERE t.C_STATUS = ‘2‘ START WITH T.C_REFER_PK_ID IS NULL CONNECT BY PRIOR C_PK_ID = C_REFER_PK_ID;
oracle函数之----sys_connect_by_path 详解
原文：https://www.cnblogs.com/liuyitan/p/10695886.html