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;