This content has been marked as final. Show 2 replies
The posted codes are having syntax errors..
You could use SYS_CONNECT_BY_PATH
select name,title, ltrim(max(sys_connect_by_path(department_text,',')),',') dep_text, max(enddate) end_dt, max(startdate) s_dt from test_table start with lvl = 1 connect by lvl = prior lvl + 1 and prior name = name group by name,title;