Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
select deptno,ename from scott.emp
select
deptno,
substr(max(sys_connect_by_path(ename,',')),2) names
from
(
select deptno,ename,row_number()
over (partition by deptno order by ename) rn
from scott.emp
)
start with rn=1
connect by prior rn = rn -1
and prior deptno = deptno
group by deptno
order by deptno
SELECT
deptno,
xmlagg (xmlelement (c, ename || ',')
order by ename).extract ('//text()' ) x
FROM scott.emp
GROUP BY deptno