ORACLE PIVOT sample

SELECT     SUBSTR (MAX (SYS_CONNECT_BY_PATH (scname, ',')), 2) scname,
              SUBSTR (MAX (SYS_CONNECT_BY_PATH (sccode, ',')), 2) sccode
         INTO scname,
              sccode
         FROM (SELECT scname, sccode, ROWNUM rnum
                 FROM test
                )
   START WITH rnum = 1
   CONNECT BY PRIOR rnum = rnum - 1;