retrieve comma separated values from database column

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Khandekar · Answer 1 · 2013-10-15T22:37:00

Solution 1

Hello Shan,

For Oracle 11g R2 you can try following syntax

SQL

SELECT LISTAGG(COLUMN_NAME, ', ') WITHIN GROUP (ORDER BY COLUMN_NAME)
FROM TABLE

More details can be found here[^].

Regards,

Posted 15-Oct-13 22:37pm

Prasad Khandekar

Comments

Thanks7872 16-Oct-13 4:38am

Repost.

http://www.codeproject.com/Questions/669361/data-table-comma-separated-values

Prasad Khandekar 16-Oct-13 4:44am

It looks bit different, it talks about datatable and probably requires a different solution.

Thanks7872 16-Oct-13 4:46am

What? looks different? How? Just visually? He explained in detail there and shortened here.

Prasad Khandekar 16-Oct-13 5:01am

Hello Rohan,

He is looking a C# solution in that thread and has also given the answer in the same. However in this question he is asking whether it can be done via a database query.

(I really liked the quote you have used on your profile)

Regards,

Thanks7872 16-Oct-13 5:07am

Oh..Thanks. :-)

ManojDhobale · Answer 2 · 2013-10-15T22:49:00

Solution 2

XML

Get list all colums names in datatable from oracle using below query

SELECT column_name
 FROM user_tab_cols
 WHERE table_name=UPPER('APP_COUNTRY_MASTER')

In c# you can put commas between names

Posted 15-Oct-13 22:49pm

ManojDhobale