column wise Data after wmsys.wm_concat [message #448712] |
Wed, 24 March 2010 23:31  |
rakeshramm
Messages: 175 Registered: September 2006 Location: Oracle4u.com
|
Senior Member |

|
|
select deptno,wmsys.wm_concat(ename) ename from scott.emp group by deptno
DEPTNO ENAME
10 CLARK,KING,MILLER
20 SMITH,FORD,ADAMS,SCOTT,JONES
30 ALLEN,BLAKE,MARTIN,TURNER,JAMES,WARD
the output i want is
DEPTNO ENAME ENAME ENAME ENAME ENAME ENAME
10 CLARK KING MILLER
20 SMITH FORD ADAMS SCOTT JONES
30 ALLEN BLAKE MARTIN TURNER JAMES WARD
Please guide me .Thanks in advance
|
|
|
|
|
|
|
|
|
Re: column wise Data after wmsys.wm_concat [message #448744 is a reply to message #448724] |
Thu, 25 March 2010 01:44  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
What you have and want is unclear. You are starting from what to go to what?
Post a working Test case: create table and insert statements along with the result you want with these data then we will work with your table and data.
Regards
Michel
Tell me and I'll forget; show me and I may remember; involve me and I'll understand
[Updated on: Thu, 25 March 2010 01:45] Report message to a moderator
|
|
|