SELECT deptno, wm_concat(ename) AS EMP_STRING FROM emp GROUP BY deptno;

how to get enames with comma seperated values by deptwise
on emp table?

Question Posted / kavitha nedigunta

Answer Posted / kavitha nedigunta

SELECT deptno, wm_concat(ename) AS EMP_STRING
FROM emp
GROUP BY deptno;

works in 10g

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are sql built in functions?

891

What are functions in sql?

888

Is sql database free?

923

How to process query result in pl/sql?

1057

What is a table?

955

What is minus?

940

What are the disadvantages of not performing database normalization?

1091

What is embedded sql with example?

984

Can a key be both primary and foreign?

943

What is a procedure in pl sql?

1123

What are few of the schema objects that are created using PL/SQL?

965

What are aggregate functions in sql?

1087

What is scope and visibility in PL/SQL?

1109

What are different functions in sql?

894

What is a clob in sql?

964