View Data in Row

Data
EMPID
DEPT
------------
1
A
B
C
Required
EMPID DEPT
------------
1 A, B, C

Can write SQL for above.
CREATE TYPE varchar2_table_t AS TABLE OF VARCHAR2(32767);SELECT empid, CAST(MULTISET(SELECT dept FROM emp WHERE empid = e.empid) ASvarchar2_table_t) FROM emp e GROUP BY empid;