Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Concat rows values into single column

dbdanJun 25 2009 — edited Nov 6 2012
Hi All,

How can I concat values of a multiple rows into a single column by separating them by comma.
Eg:

SELECT empno FROM emp;
empno
1
2
3
4

I want output should be:
Empnos
1,2,3,4

Thanks & Regards,
Danish

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 4 2012
Added on Jun 25 2009
13 comments
74,117 views