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

What is a behavioral trigger?

961

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1246

---

What is the difference between database trigger and stored procedure?

1059

---

Which software is used for pl sql programming?

970

---

What is difference between primary and secondary key?

1009

---

How many sql commands are there?

1102

---

What is the difference between clustered and non-clustered index in sql?

987

---

Can we insert data into view?

891

---

What is meant by user defined function?

1028

---

Does sql require a server?

994

---

What is data types in sql?

983

---

What is string join?

962

---

Mention what does the hierarchical profiler does?

1066

---

What is percent sign in sql?

1266

---

What is scope and visibility in PL/SQL?

1179

---