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

Which are the different types of indexes in sql?

1100

What is a unique constraint?

1125

how to analyze tables with 'mysqlcheck'? : Sql dba

1061

What are all the common sql functions?

1084

How much does sqlite cost?

1094

What is a null value?

1191

Can sql developer connect to db2?

1104

What is sql mysql pl sql oracle?

1129

explain access control lists. : Sql dba

1050

What is clustered and nonclustered index in sql?

986

What is the difference between numeric and autonumber?

1039

How do you bind variables in pl sql?

1160

What is difference between stored procedures and application procedures?

1067

What is dba in sql? : SQL DBA

1094

Is nosql relational?

1000