Oracle Display the values of columns in single row without using connect by clause

Question

This is my query

 select deptno,ename from emp_task;

Output

enter image description here

I want the output like this

eno      ename
20    TRINATH/RABHA
8     SAIKIRAN/KISHORE
10    KUMAR/VICKY/DAFNI

possible duplicate of [SQL Query to concatenate column values from multiple rows in Oracle](http://stackoverflow.com/questions/4686543/sql-query-to-concatenate-column-values-from-multiple-rows-in-oracle) — MT0, Jun 20 '15 at 10:21
Duplicate of [this](http://stackoverflow.com/q/4686543/1509264), [this](http://stackoverflow.com/q/492563/1509264), [this](http://stackoverflow.com/q/468990/1509264) and [this](http://stackoverflow.com/q/4686543/1509264) (and probably more). — MT0, Jun 20 '15 at 10:23

score 0 · Answer 1 · answered Jun 20 '15 at 09:26

0

select deptno,
       listagg(ename,'/') within group (order by ename) as names
from temp_task
group by deptno
order by deptno;

answered Jun 20 '15 at 09:26

@PrabhaChrist: works for me: http://sqlfiddle.com/#!4/a766a/1 (and "*not working*" is not a valid Oracle error message) – Jun 22 '15 at 05:45
This is the error i got "FROM keyword not found where expected" – Prabha Christ Jun 22 '15 at 06:40

score 0 · Answer 2 · edited Jun 22 '15 at 07:24

0

This sql query should work -

select deptno,wm_concat(ename) 
from emp_task 
group by deptno 
order by deptno

edited Jun 22 '15 at 07:24

divyanshm

answered Jun 22 '15 at 05:44

Prabha Christ

`wm_concat` is an unsupported and undocumented oracle function (use at your own risk); also its not present in all installations (its not available on any of the 11g instances I run). `LISTAGG` is documented and should be used instead. – MT0 Jun 22 '15 at 08:44

2 Answers2