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;