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

Is primary key an index?

999

What is varchar example?

1039

what is view? : Sql dba

972

What is input buffer in sql*plus?

1232

how to delete an existing column in a table? : Sql dba

1010

How do I run a sql query?

1029

What do you mean by stored procedures?

1017

what is the use of friend function? : Sql dba

1025

Can dml statements be used in pl/sql?

1089

What are the built in functions of sql?

1032

what are the advantages and disadvantages of views in a database? : Sql dba

1044

How to Declare Fixed Length String Value In PL SQL

1158

What is sql scripting?

1127

What is union and union all keyword in sql?

1050

What is the difference between partitioning and sharding?

1013