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

How does a covering index work?

971

---

Is sql a scripting language?

1024

---

What do you understand by exception handling in pl/sql?

1040

---

Explain select statements in sql?

1063

---

What is a sql statement?

975

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

967

---

What does select * from mean in sql?

3251

---

What is data type in sql?

974

---

How to create a menu in sqlplus or pl/sql?

1131

---

How do I run sql profiler?

1077

---

What is the difference between an inner join and an outer join?

1033

---

Can one improve the performance of sql*loader? : aql loader

1055

---

Which kind of parameters cannot have a default value in pl sql?

1157

---

How do I get sql certification?

978

---

What is sql profiler in oracle?

1101

---