COLUMN employees FORMAT A50 SELECT deptno, wm

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

Question Posted / amitabha mandal

8 Answers
11591 Views
I also Faced
E-Mail Answers

Answer Posted / amitabha mandal

COLUMN employees FORMAT A50

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

DEPTNO EMPLOYEES
---------- -------------------------------------------------
-
10 CLARK,KING,MILLER
20 SMITH,FORD,ADAMS,SCOTT,JONES
30 ALLEN,BLAKE,MARTIN,TURNER,JAMES,WARD

3 rows selected.

check tyhis link :http://www.oracle-
base.com/articles/misc/StringAggregationTechniques.php

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we insert data in view?

888

What is update query?

920

What is an emotional trigger?

930

What is sequence in sql?

938

How do you use collections in procedure to return the resultset?

2181

Is a view faster than a stored procedure?

900

What is a Mapplet?

1057

What is crud diagram?

877

Can we use update in sql function?

1006

Can you join a table to itself?

1030

what are the performance and scalability characteristics of mysql? : Sql dba

943

What are the types of subqueries?

1014

What is an exception in PL/SQL? What are the two types of exceptions?

1193

Can we create table inside stored procedure?

904

What is sql analyzer?

959