This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jul 5, 2007 9:04 AM by Alessandro Rossi RSS

how to display empno in a single row instead of displaying it vertically

223127 Newbie
Currently Being Moderated
Hi All,
Greetings!

Requirement :
A select statement to display empno horizontally instead of vertical display at sql prompt.
For Eg:

SQL> Select empno from emp;
empno
--------
9999
2222
3333
4444
5555
...
...
...
...

Instead want the display of data in the below format

empno
----------
9999,2222,3333,4444,5555..........

Thanks in advance.

Regards,
Naveen.
1 2 Previous Next