从数据库列中检索逗号分隔值 [英] retrieve comma separated values from database column

问题描述

如何从oracle中用逗号分隔的数据库列中检索所有值。

How can i retrieve all values from database column separated by comma in oracle.

推荐答案

Hello Shan，



对于Oracle 11g R2，您可以尝试以下语法

Hello Shan,

For Oracle 11g R2 you can try following syntax

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

可以找到更多细节这里 [ ^ ]。



问候，

More details can be found here[^].

Regards,

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

这篇关于从数据库列中检索逗号分隔值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！