Oracle函数之 ---- sys_connect_by_path

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;

 链接