Hi,
Group_concat is avilable in Mysql server only,but oracle has equalient group concat functionality that achived in simple query.it is given as below


CREATE OR REPLACE TYPE ntt_varchar2 AS TABLEOF VARCHAR2(4000);
select deptno, cast(collect(ename) as ntt_varchar2) as vals from emp group by deptno