Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

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

naveenhksNov 11 2005 — edited Nov 6 2010
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2007
Added on Nov 11 2005
18 comments
19,191 views