There are native SQL techniques to display multiple columns onto a single row

    * Oracle 9i xmlagg

In Oracle 9i we can use the xmlagg function to aggregate multiple rows onto one column:

select
   deptno,
   rtrim (xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames
from
   emp
group by
   deptno
;

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

Labels: kludge, noteToSelf, oracle