* 하고 싶은 일
a
b --> a, b, c
c
* SQL
SELECT SUBSTR (MAX (SYS_CONNECT_BY_PATH(ch, ',')), 2) path#
FROM (SELECT ch, ROWNUM rnum
FROM abc)
START WITH rnum = 1
CONNECT BY PRIOR rnum = rnum - 1
* 하고 싶은 일
a
b --> a, b, c
c
* SQL
SELECT SUBSTR (MAX (SYS_CONNECT_BY_PATH(ch, ',')), 2) path#
FROM (SELECT ch, ROWNUM rnum
FROM abc)
START WITH rnum = 1
CONNECT BY PRIOR rnum = rnum - 1