hi guys,

pl. find a solution for this :

assuming a simple table, that an emp table has got 3 cols like empno,ename,esal. and contains 10 rows.

if we give select empno,ename,esal from emp;
it will list you all ten rows corresponding to empno.

but i want to see only all empno's in horizontal manner at a time.

ie., not like :

empno
=====
1001
1002
1003
..
..
1010

but i want see them like

empno
=====
1001, 1002, 1003, ....1010

at sql prompt

thanks