how to display empno in a single row instead of displaying it vertically
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.