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 :
but i want see them like
1001, 1002, 1003, ....1010
at sql prompt