Oracle Display the values of columns in single row without using connect by clause

Question

This is my query

 select deptno,ename from emp_task;

Output

I want the output like this

eno      ename
20    TRINATH/RABHA
8     SAIKIRAN/KISHORE
10    KUMAR/VICKY/DAFNI

Answer 1

select deptno,
       listagg(ename,'/') within group (order by ename) as names
from temp_task
group by deptno
order by deptno;

Answer 2

This sql query should work -

select deptno,wm_concat(ename) 
from emp_task 
group by deptno 
order by deptno